| 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/20243/CST1600/41/00193071/Lab07/ |
Upload File : |
UNF: student(Name, HomeMobilePhoneNumbers, StudentID, MajorCode1, MajorCode2, MajorCode3) 1NF: 1)Primary Key is (studentID*). 2) The HomeMobilePhoneNumbers does not pass 1NF. Has more than 1 value in the column. Made a "student_phone" table that lists the all phone numbers for each (studentID) then with a (typephone) column lists the type of phone each number is. TABLES: student (studentID*, studentName, MajorCode1, MajorCode2, MajorCode3) student_phone (studentID*@, phoneNumber, typephone;) 2NF: 1)"student" table violates 2NF. While students have a major or many majors. The Major does not depend on the student to exist. 2) Adding a new table "major" that combines (MajorCode1, MajorCode2, MajorCode3) into one column (Majorcode*) that lists all majors. Not all students have multiple majors. 3) Adding a new table "student_major" that links the "student" table to the "major" table. This will give you which majors each student is taking. TABLES: student (studentID*, studentName) student_phone (studentID*@, phoneNumber, typephone;) student_major (studentID*@, Majorcode*@) major (Majorcode*) 3NF: OK for 3NF Three data rows: student (studentID*, studentName) 34673656 Avram Hinton 83681840 Hayes Gibson 94086534 Kristen Acosta student_phone (studentID*@, phoneNumber, typephone;) 34673656 103-391-7811 home 34673656 676-683-6301 mobile 83681840 447-149-5334 home 94086534 972-658-1570 home student_major (studentID*@, Majorcode*@) 34673656 NSA 34673656 CSS 34673656 CST 83681840 CST 94086534 CP 94086534 MAD major (Majorcode*) CP CSS CST MAD NSA