| 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/16843769/Lab07/ |
Upload File : |
UNF:
student(Name, HomeMobilePhoneNumbers, StudentID, MajorCode1, MajorCode2, MajorCode3)
1NF:
Notes:
1)There is repetition in the name and phone numbers. Plus the majors don't allow for more than 3, when it shout be unlimited.
2)I got rid of MajorCode1, MajorCode2, and MajorCode3. Instead using just majorCode to allow for an unlimited amount
3)got rid of HomeMobilePhoneNumber and just made it phone and added type to tell the difference from mobile to home numbers.
4)StudentID is now student_id
5) split name into fistName and LastName
major(majorCode*)
student_id(studentID*)
phone_number(student*@, phone*, type)
student(studentID*@, firstName, lastName)
student_major(studentID*@, majorCode*@)
2NF:
Notes:
1)OK
3NF:
Notes:
1)OK
major(majorCode*)
student_id(studentID*)
phone_number(student*@, phone*, type)
student(studentID*@, firstName, lastName)
student_major(studentID*@, majorCode*@)
Three data rows:
major (majorCode*)
NSA
CSS
CST
CP
MAD
student_id (studentID*)
34673656
83681840
94086534
phone_number (studentID*@, phone*, type)
34673656, 103-391-7811, home
83681840, 447-149-5334, home
94086534, 972-658-1570, home
34673656, 676-683-6301, mobile
student (studentID*@, firstName, LastName)
34673656, Avram, Hinton
83681840, Hayes, Gibson
94086534, Kristen, Acosta
student_major (studnetID*@, majorCode*@)
34673656, NSA
34673656, CSS
34673656, CST
83681840, CST
94086534, CP
94086534, MAD