| 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/uploads/20243/CST1600/41/16302623/Lab07/ |
Upload File : |
UNF: student(Name, HomeMobilePhoneNumbers, StudentID, MajorCode1, MajorCode2, Majorcode3) 1NF: Violation the HomeMobilePhoneNumber column contains multiple values which violates 1NF as it requires atomicity Name | HomeMobilePhoneNumber |* studentID | MajorCode -----|-----------------------|-----------|---------- Avram Hinton | 103-391-7811 | 34673656 | NSA Avram Hinton | 676-683-6301 | 34673656 | CSS Avram Hinton | 676-683-6301 | 34673656 | CST Hayes Gibson | 447-149-5334 | 83681840 | CST Kristen Acosta | 972-658-1570 | 94086534 | CP Kristen Acosta | 972-658-1570 | 94086534 | MAD 2NF: Violation: The table still contains partial dependency MajorCode depends on studentID but not on HomeMobilePhoneNumber Students Table: studentID | Name | HomeMobilePhoneNumber ----------|------|----------------------- 34673656 | Avram Hinton | 103-391-7811 34673656 | Avram Hinton | 676-683-6301 83681840 | Hayes Gibson | 447-149-5334 94086534 | Kristen Acosta | 972-658-1570 Majors Table: studentID | MajorCode ----------|---------- 34673656 | NSA 34673656 | CSS 34673656 | CST 83681840 | CST 94086534 | CP 94086534 | MAD 3NF: OK Students Table: studentID | Name | HomeMobilePhoneNumber ----------|------|----------------------- 34673656 | Avram Hinton | 103-391-7811 34673656 | Avram Hinton | 676-683-6301 83681840 | Hayes Gibson | 447-149-5334 94086534 | Kristen Acosta | 972-658-1570 Majors Table: studentID | MajorCode ----------|---------- 34673656 | NSA 34673656 | CSS 34673656 | CST 83681840 | CST 94086534 | CP 94086534 | MAD Three data rows: