| 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/20253/CST1600/41/16422751/Lab07/ |
Upload File : |
UNF: student(Name, HomeMobilePhoneNumbers, StudentID, MajorCode1, MajorCode2, MajorCode3) 1NF: -Primary key is student id as that is the identifying aspect of each line -HomeMobliePhoneNumbers has multiple values which violates 1NF so the table Phone_Numbers is added so each number has its own line, this table also contains StudentID we will also create a PhoneNumberId to be able to acsess the number exactly, and fially we will add a PhoneType to identify wheather the number is a home phone number or a mobile phone number we also change the field name HomeMobliePhoneNumbers to PhoneNumbers -Since not all student have 3 majors, we will take MajorCode1, MajorCode2, and MajorCode3 and combining them all into one field of MajorCode -We then create a new table call Student_Majors in which we have StudentID and MajorCode in which each major gets its own line in a one-to-many table so that it doesn’t violate 1NF Student (StudentID*, Name) Phone_Numbers(Phone_Number_ID*, StudentID@ , PhoneType, PhoneNumbers) Student_Majors(StudentID*@, MajorCode^) 2NF: the tables we have only has one primary key so none of the fields can be partially dependent so it is ok for 2NF 3NF: again since there is only primary keys all of the non primary keys In each table relys on the primary key so the tables are also in complice with 3NF Three data rows: Student (StudentID, Name) 34673656 , Avram Hinton 83681840 , Hayes Gibson 94086534 , Kristen Acosta Phone_Numbers(Phone_Number_ID, StudentID, PhoneType, PhoneNumbers) 1 , 34673656 , Home , 103-391-7811 2 , 34673656 , Mobile , 676-683-6301 3 , 83681840 , Home , 447-149-5334 4 , 94086534 , Mobile , 972-658-1570 Student_Majors(StudentID, MajorCode) 34673656 , NSA 34673656 , CSS 34673656 , CST 83681840 , CST 94086534 , CP 94086534 , MAD