1.sno,pno,dept
2.第二范式
3.
第三范式:
sp1(sno,dept,city,sname,dname)
sp2(pno,color,weight,pname)
sp3(sno,pno,qty)
第四范式:
sp1(sno,dept,city,sname)
sp2(pno,color,weight,pname)
sp4(sno,pno,qty)
2.第二范式
3.
第三范式:
sp1(sno,dept,city,sname,dname)
sp2(pno,color,weight,pname)
sp3(sno,pno,qty)
第四范式:
sp1(sno,dept,city,sname)
sp2(pno,color,weight,pname)
sp4(sno,pno,qty)
2.第二范式
3.
sp1(sno,dept,city,sname)
sp2(dept,dname)
sp3(pno,color,weight,pname)
sp4(sno,pno,qty)
sp1(sno,dept,city,sname)
sp2(pno,color,weight,pname)
sp3(dept,dname)
sp4(sno,pno,qty)
sp1(sno,dept,city,sname,dname)
是错的,sno--〉dept--〉dname,传递依赖