| 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/16574034/Lab07/ |
Upload File : |
UNF: student(Name, HomeMobilePhoneNumbers, StudentID, MajorCode1, MajorCode2, MajorCode3) 1NF: The HomeMobilePhoneNumebrs in the UNF violates 1NF by having multiple values in a column. student(*StudentID, Name, HomePhoneNumber, MobilePhoneNumber, Major) I created this table with these fields as there will be no repeating data or attributes and no fields with multiple values in them. This table seperates repeating of phone numbers when multiple majors are listed if the student has more than 1. This way we are not repeating data. 2NF: student(*StudentID, Name, HomePhoneNumber, MobilePhoneNumber) major(@StudentID, *MajorID, Major) This table seperates repeating of phone numbers when multiple majors are listed if the student has more than 1 major. This way we are not repeating data. We also add a primary id called MajorID in the major table to allow for major to have complete dependency on the MajorID but not the student ID 3NF: student(*StudentID, Name, HomePhoneNumber, MobilePhoneNumber) major(@StudentID, @MajorID) subject(*MajorID, Major) Now the table shows 3NF because Major does not depend on the student ID but on the major ID. Three data rows: *StudentID Name HomePhoneNumber MobilePhoneNumber 1 Joe Lee 333-453-7693 null 2 West East 498-243-6474 887-361-4921 3 Wendy Lock 783-928-7634 643-123-1211 *MajorID Major 1 Vet tech 2 CNA 3 Egineer @StudentID @MajorID 1 3 1 2 3 1