| 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/15650461/Lab07/ |
Upload File : |
UNF:
student(Name, HomeMobilePhoneNumbers, StudentID, MajorCode1, MajorCode2, MajorCode3)
1NF:
The student table violates 1NF because it has multiple values in the HomeMobilePhoneNumbers field and has repeating fields in MajorCode1, MajorCode2, and MajorCode3.
I'm going to create three new tables in addition to student (studentPhone, major, and studentMajor) and change the student table to include lastname and firstname.
student(StudentID*, firstName^, lastName^)
studentPhone(StudentId@, Phone*, Type^)
major(MajorId*, MajorCode^)
studentMajor(StudentId@, MajorID@)
2NF:
OK
3NF:
OK
Three data rows:
student(StudentID*, firstName^, lastName^)
34673656, Avram, Hinton
83681840, Hayes, Gibson
94086534, Kristen, Acosta
studentPhone(StudentId@, Phone*, Type^)
34673656, 103-391-7811, home
34673656, 676-683-6301, mobile
83681840, 447-149-5334, home
94086534, 972-658-1570, mobile
major(MajorId*, MajorCode^)
1 NSA
2 CSS
3 CST
4 CP
5 MAD
studentMajor(StudentId@, MajorId@)
34673656, 1
34673656, 2
34673656, 3
83681840, 3
94086534, 4
94086534, 5