| 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/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. Added phone table to prevent data anomalies. Student table StudentID*, Name, HomePhoneNumber, MobilePhoneNumber Major table MajorCode*, MajorName Student_Major StudentID*@, MajorCode@ 2NF: Added phone table to prevent data anomalies. Added "phoneType" to determine phone type when inputting data to bring both home and mobile phone numbers into one column, renamed as "phoneNumber" Student table StudentID*, Name, HomePhoneNumber, MobilePhoneNumber Phone table StudentID@Student, phoneNumber, phoneType Major table MajorCode*, MajorName Student_Major StudentID*@, MajorCode@ 3NF: OK Three data rows: Student table Student ID* Name 34673656 Avram Hinton 83681840 Hayes Gibson 94086534 Kristen Acosta Phone table Student ID@ phoneNumber phoneType 34673656 103-391-7811 Home 34673656 676-683-6301 Mobile 83681840 447-149-5334 Home 94086534 972-658-1570 Home 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