| 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 : /nginx/html/uploads/20243/CST1600/41/16513508/Lab07/ |
Upload File : |
UNF: student(Name, HomeMobilePhoneNumbers, StudentID, MajorCode1, MajorCode2, MajorCode3) 1NF: Note: In the UNF table, we have repeating fields (MajorCode1, MajorCode2, MajorCode3) which violate 1NF. To resolve this, we'll create a new table StudentMajors to hold the student's majors. student(Name, HomeMobilePhoneNumbers, StudentID*) StudentMajors(StudentID*@, MajorCode*) 2NF: Note: What makes the 1NF not 2NF legal is the presence of partial dependencies in the original structure. In 1NF, the MajorCode attributes depend on the entire candidate key (StudentID) rather than just part of it. By breaking down the original table into separate tables and establishing relationships, we eliminate partial dependencies and achieve 2NF. Student(Name, HomeMobilePhoneNumbers, StudentID*) StudentMajors(StudentID*@, MajorCode*@) Major(MajorCode*) 3NF: Note: OK Student(Name, HomeMobilePhoneNumbers, StudentID*) StudentMajors(StudentID*@, MajorCode*@) Major(MajorCode*) Three data rows: Student(Name, HomeMobilePhoneNumbers, StudentID*) Avram Hinton 103-391-7811;676-683-6301 34673656 Hayes Gibson 447-149-5334 83681840 Kristen Acosta ;972-658-1570 94086534 StudentMajors(StudentID*@, MajorCode*@) 34673656 NSA 34673656 CSS 34673656 CST 83681840 CST 94086534 CP 94086534 MAD Major(MajorCode*) NSA CSS CST CP MAD