数据库实验报告_4.docVIP

Uyear Uyear Uname UplaceUno Uplace Uno BelongSdnameSdorSclnoSnoSnameSageLiveDeptMajorClassStudentSunion Belong Sdname Sdor Sclno Sno Sname Sage Live Dept Major Class Student Sunion J Joinyear Sjoin m Sjoin n p Cnum Cnum q Clyear 1 Clyear C Clmjname BelongOpenClno Belong Open Clno Mname Mname Cldname 1 1 DnoBelong n Dno Belong DnameDorplace Dname Dorplace DormitoryDwkplace 1 1 Dormitory Dwkplace Dnum Dnum 消除冲突和冗余后的E-R图 Uyear Uyear Uplace U Uname Uno Uno Sunion Sunion Joinyear Joinyear Sjoin m Sjoin DorplaceDormitoryDnumDnameDwkplaceDnoBelongMjnamelyearClnumClnoOpenBelongSnoSnameSageLiveD