| 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/16316941/Lab07/ |
Upload File : |
UNF:
student(Name, HomeMobilePhoneNumbers, StudentID, MajorCode1, MajorCode2, MajorCode3)
Note: Name has two things of data, first and last name. there are also two diffrent types of phone numbers in
HomeMobilePhoneNumber. multiple tables with the same type of data with majorCodes and not eveyone has three major codes
1NF: studentName(StudentID*, FirstName, LastName)
studentPhone(StudentID*@, PhoneNumber*, Type)
majors(MajorCode*)
studentMajor(StudentID*@, MajorCode*@)
Note: OK
2NF: studentName(StudentID*, FirstName, LastName)
studentPhone(StudentID*@, PhoneNumber*, Type)
majors(MajorCode*)
studentMajor(StudentID*@, MajorCode*@)
Note: OK
3NF: studentName(StudentID*, FirstName, LastName)
studentPhone(StudentID*@, PhoneNumber*, Type)
majors(MajorCode*)
studentMajor(StudentID*@, MajorCode*@)
Three data rows: studentName(StudentID*, FirstName, LastName)
34673656, Avram, Hinton
83681840, Hayes, Gibson
94086534 Kristen, Acosta
studentPhone(StudentID*@, PhoneNumber*, Type)
34673656, 103-391-7811, Home
34673656, 676-683-6301, Mobile
83681840, 447-149-5334, Home
94086534, 972-658-1570, Mobile
majors(MajorCode*)
CP
CSS
CST
MAD
NSA
studentMajor(StudentID*@, MajorCode*@)
34673656, CSS
34673656, CST
34673656, NSA
83681840, CST
94086534, CP
94086534, MAD