| 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/20245/CST1600/41/16411022/Lab07/ |
Upload File : |
UNF: student(Name, HomeMobilePhoneNumbers, StudentID, MajorCode1, MajorCode2, MajorCode3) 1NF: No primary key, HomeMobilePhoneNumbers has multiple values in some rows. I seperated the home and phone numbers into seperate columns titled HomePhoneNumber and MobilePhoneNumber There are repeating groups in MajorCode1, MajorCode2, and MajorCode3. I created a seperate relation for them. Added Student_Major table to join together Student and Major table. Student table StudentID*, Name, HomePhoneNumber, MobilePhoneNumber Major table MajorCode*, MajorName Student_Major StudentID*@, MajorCode@ 2NF: OK 3NF: OK Three data rows: Student table Student ID* Name HomePhoneNumber MobilePhoneNumber 34673656 Avram Hinton 103-391-7811 676-683-6301 83681840 Hayes Gibson 447-149-5334 94086534 Kristen Acosta 972-658-1570 Major table MajorCode* MajorName 1 CP 2 CSS 3 CST 4 MAD 5 NSA 6 WP Student_Major table StudentID*@ MajorCode@ 34673656 2 34673656 3 34673656 5 83681840 3 94086534 1 94086534 4