| 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/16801913/Lab07/ |
Upload File : |
UNF: student(Name, HomeMobilePhoneNumbers, StudentID, MajorCode1, MajorCode2, MajorCode3) 1NF: Originally the MajorCode 1, 2, 3 had values that were being repeated. Combined them into one table, Majors, and added a MajorName. Student's personel info is in its own table. Created a PK for the Student Majors table with StudentID+MajorCode. Student (*StudentID, Name, HomeMobilePhoneNumbers) Majors (*MajorCodes, MajorName) Student Majors (@StudentID, @MajorCode,Name, MajorName) > (*StudentID+MajorCode, Name, MajorName) 2NF: All primary keys are single column. Student (*StudentID, Name, HomeMobilePhoneNumbers) ok Majors (*MajorCode, MajorName) ok Student Majors(*StudentID+MajorCode, Name, MajorName) ok 3NF: Broke apart the table Student to seperate the Names and their numbers. Removed MajorNames from Student Student(*StudentID, Name) Phone Numbers (*StudentID, HomeMobilePhoneNumbers) StuMajors(*StudentID+MajorCode, Name) Majors(*MajorCode, MajorName) Three Data Rows Student StudentID Name 34673656 Avram Hinton 83681840 Hayes Gibson 94086534 Kristen Acosta Phone Numbers Student ID HomeMobilePhoneNumbers 34673656 103-391-7811;676-683-6301 83681840 447-149-5334 940865534 972-658-1570 StuMajors StudentID+MajorCode Name 34673656NSA Avram Hinton 34673656CSS Avram Hinton 34673656CST Avram Hinton 83681840CST Hayes Gibson 94086534CPMAD Kristen Acosta Majors MajorCode MajorName NSA NetworkSecurity CSS Computational Social Science CST ComputerScience