| 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/16910162/Lab07/ |
Upload File : |
UNF:
student(Name, HomeMobilePhoneNumbers, StudentID, MajorCode1, MajorCode2, MajorCode3)
1NF:
StudentMajor Table
Fields: StudentMajorID (Primary Key), StudentID (Foreign Key), MajorCode
Reason: To handle multiple majors per student.
Student Table
Fields: StudentID (Primary Key), Name
Reason: Contains student details; HomeMobilePhoneNumbers and MajorCodes moved to separate tables.
StudentTable (StudentID, Name)
StudentPhoneTable (StudentPhoneID, StudentID, PhoneNumber)
StudentMajorTable (StudentMajorID, StudentID, MajorCode)
Added StudentPhoneID and StudentMajorID as primary keys in StudentPhone and StudentMajor tables to uniquely identify each entry.
Removed repeating fields MajorCode1, MajorCode2, and MajorCode3.
2NF: OK
3NF:
StudentTable (StudentID, Name)
StudentPhoneTable (StudentPhoneID, StudentID, PhoneNumber)
StudentMajorTable (StudentMajorID, StudentID, MajorCode)
Three data rows:
Student Table
StudentID Name
1 Alice
2 Bob
3 Charlie
StudentPhone Table
StudentPhoneID StudentID PhoneNumber
1 1 123-456-7890
2 1 098-765-4321
3 2 555-555-5555
StudentMajor Table
StudentMajorID StudentID MajorCode
1 1 CS
2 1 MATH
3 2 ENG