| Server IP : 134.29.175.74 / Your IP : 216.73.216.160 Web Server : nginx/1.10.2 System : Windows NT CST-WEBSERVER 10.0 build 19045 (Windows 10) i586 User : Administrator ( 0) PHP Version : 7.1.0 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/nginx/html/JimMartinson/CST1600/_Archive/Notes/ |
Upload File : |
CST1600_wk12_20180327_part1 View lecture part 1 CST1600_wk12_20180327_part2 View lecture part 2 CST1600_wk12_20180327_part3 View lecture part 3 (Lab 5) * = primary key (unique identifier) @ = foreign key (points to a primary key or unique identifier in another table) ^ - unique field. ================================================== 1NF: Class(ClassId*, ClassNo, Sec, Title, Cr, Enr, Max, sDate, eDate, Day*, sTime*, eTime*, BLdg^, Rm^, Instructor*) ClassId* ClassNo Sec Title Cr Enr Max sDate - eDate Day* sTime* eTime* Bldg* Rm* Instructor* 000755 MMDT1180 41 Multimedia Portfolio 4 9 30 01/08/18 - 05/11/18 Arranged ON Online Benusa, Allen 000755 MMDT1180 41 Multimedia Portfolio 4 9 30 01/08/18 - 05/11/18 Arranged ON Online Maher, Amy 000755 MMDT1180 41 Multimedia Portfolio 4 9 30 01/08/18 - 05/11/18 H 10:00am-10:50am B 67 Benusa, Allen 000755 MMDT1180 41 Multimedia Portfolio 4 9 30 01/08/18 - 05/11/18 H 10:00am-10:50am MAINHU 475 Benusa, Allen 2NF: Class(ClassId*, ClassNo, Sec, Title, Cr, Enr, Max, sDate, eDate) ClassId* ClassNo Sec Title Cr Enr Max sDate - eDate 000755 MMDT1180 41 Multimedia Portfolio 4 9 30 01/08/18 - 05/11/18 Class_Time_Rm_Instructor (ClassId*@, tId*@, rId*@, IId*@) ClassId*@ tId*@ rId*@ IId*@ 000755 1 1 1 000755 1 1 2 Class_Time(tId*, Day, sTime, eTime* tId* Day* sTime* eTime* 1 Arranged 2 H 10:00am 10:50am Class_Rm(rId*, Bldg, Rm) rId@* BLdg Rm 1 ON Online 2 B 67 3 MAINHU 475 Class_Instructor(IId*, Instructor*) IId* Instructor* 1 Benusa, Allen 2 Maher, Amy ERROR: Class_Rm, Class_Time, Class_Instructor have lost the link between themselves. Ask yourself how I know the day we meet in B67. 2NF: Class(ClassId*, ClassNo, Sec, Title, Cr, Enr, Max, sDate, eDate) ClassId* ClassNo Sec Title Cr Enr Max sDate - eDate 000755 MMDT1180 41 Multimedia Portfolio 4 9 30 01/08/18 - 05/11/18 Class_Meeting(ClassId*@, Day*, sTime*, eTime*, BLdg^, Rm^, Instructor*) ClassId*@ Day* sTime* eTime* Bldg* Rm* Instructor* 000755 Arranged ON Online Benusa, Allen 000755 Arranged ON Online Maher, Amy 000755 H 10:00am-10:50am B 67 Benusa, Allen 000755 H 10:00am-10:50am MAINHU 475 Benusa, Allen 3NF: Class(ClassId*, ClassNo@, Sec, Enr, Max, sDate, eDate, Online) ClassId* ClassNo@ Sec Enr Max sDate - eDate Online 000755 MMDT1180 41 9 30 01/08/18 - 05/11/18 Yes Course(ClassNo*, Title, Cr) ClassNo* Title Cr MMDT1180 Multimedia Portfolio 4 Class_Meeting(ClassId*@, Day*, sTime*, eTime*, RmId*@, InstructorId*@) ClassId*@ meetingtimeId*@ RmId* InstructorId*@ 000755 1 1 000755 1 2 000755 2 2 1 000755 3 2 1 000755 2 1 1 000755 3 1 1 MeetingTime (meetingtimeId*, day, bTime, eTime, Arranged) meetingtimeId* day bTime eTime Arranged 1 Yes 2 T 10:00am 10:50am 3 H 10:00am 10:50am Bldg(BldgId*, BldgName) BldgId* BldgName 1 MAINHU 2 B Rm(RmId*, BldgId@, Rm) RmId* BldgId@ Rm 1 1 475 2 2 67 3 1 327 4 2 48 Instructor(InstructorId*, FirstName, LastName) InstructorId* FirstName LastName 1 Allen Benusa 2 Amy Maher ClassId* ClassNo Sec Title Cr Enr Max sDate - eDate Day* sTime* eTime* Bldg* Rm* Instructor* 000755 MMDT1180 41 Multimedia Portfolio 4 9 30 01/08/18 - 05/11/18 Arranged ON Online Benusa, Allen 000755 MMDT1180 41 Multimedia Portfolio 4 9 30 01/08/18 - 05/11/18 Arranged ON Online Maher, Amy 000755 MMDT1180 41 Multimedia Portfolio 4 9 30 01/08/18 - 05/11/18 TH 10:00am-10:50am B 67 Benusa, Allen 000755 MMDT1180 41 Multimedia Portfolio 4 9 30 01/08/18 - 05/11/18 TH 10:00am-10:50am MAINHU 475 Benusa, Allen !!!!! IF your have repeating fields they should become a one-to-many table under most circumstances. !!!!! IF a field or fields represent something in the real world, that something should have its own table.