| 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/Classes/CST1600/Week/14/ |
Upload File : |
UNF: classlist(ClassId, ClassNo, Sec, ClassTitle, Cr, Enr, Max, MeetingDates, Days, Time, Bldg, Rm, Instructor, Footnotes) 1NF: MeetingDates has a begin and end date. Create DateBegin and DateEnd Days has multiple entries. Fix that by duplicating row data, each with only one day. Field name is Day. Time has a begin and end time. Create TimeBegin and TimeEnd Designate CliassId, Day, and Rm as the PK classlist(ClassId*, ClassNo, Sec, ClassTitle, Cr, Enr, Max, DateBegin, DateEnd, Day*, TimeBegin, TimeEnd, Bldg, Rm*, Instructor, Footnotes) 2NF: Rename Bldg to buildingName. Rename Rm to roomNumber. Instrctors are entities. So give them a table. Day is computer from date. ClassNo does not depend of full PK. class(ClassId*, ClassNo, Sec, ClassTitle, Cr, Enr, Max, Footnotes) building(buildingId*, buildingName^) room(roomId*, roomNumber, buildingId@) instructor(instructorId*, instructorName) classmeeting(ClassId*@, Date*, TimeBegin*, TimeEnd*, roomId*@) class_instructor(ClassId*@, instructorId*@) 3NF: DateBegin, DateEnd changed to just Date. There will be one classmeeting for each date between DateBegin, DateEnd. ClassTitle depends on ClassNo. class(ClassId*, courseId@, Sec, Enr, Footnotes) course(courseId*, ClassNo^, ClassTitle, Cr, Max) building(buildingId*, buildingName^) room(roomId*, roomNumber, buildingId@) instructor(instructorId*, instructorName) classmeeting(ClassId*@, Date*, TimeBegin*, TimeEnd*, roomId*@) class_instructor(ClassId*@, instructorId*@)