| 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/11/ |
Upload File : |
* = primary key (PK) @ = foreign key (FK) ^ = unique field (UNI) Student_Grade_Report (StudentNo, StudentName, Major, CourseNo, CourseName, InstructorNo, InstructorName, InstructorLocation, Grade) 1NF: The course information repeates. Students can take many courses, and courses can have many students. So we make a student table and a table for the rest (plus a FK to the student table) Student (StudentNo*, StudentName, Major) StudentCourse (StudentNo*@, CourseNo*, CourseName, InstructorNo, InstructorName, InstructorLocation, Grade) 2NF: Only the grade depended on both the StudentNo and CourseNo. Move the rest of the info to another table with a PK for that table. Rename tables. Student (StudentNo*, StudentName, Major) CourseGrade (StudentNo*@, CourseNo*@, Grade) CourseInstructor (CourseNo*, CourseName, InstructorNo, InstructorName, InstructorLocation) 3NF: Instructor info did not depend on the CourseNo, so move the Instructor info to another table. Other issues: Cannot add a new Instructor without a course. Rename tables. Student (StudentNo*, StudentName, Major) CourseGrade (StudentNo*@, CourseNo*@, Grade) Course (CourseNo*, CourseName, InstructorNo@) Instructor (InstructorNo*, InstructorName, InstructorLocation)