| 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/15812201/Lab09/ |
Upload File : |
UNF: studentgrades (StudentId*, StudentName, SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total, Final, IP) lettergrade (LetterGrade1, Percentage1, LetterGrade2, Percentage2, LetterGrade3, Percentage3, LetterGrade4, Percentage4, LetterGrade5, Percentage5, LetterGrade6, Percentage6, LetterGrade7, Percentage7, LetterGrade8, Percentage8, LetterGrade9, Percentage9) possiblepoints (SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total) 1NF: -- StudentProfile Table studentprofile (StudentId*, StudentName, SP, Total, Final, IP) -- LabGrades Table labgrades (StudentId@, LabNumber*, Grade) -- LetterGrade Table (Normalized to 1NF) lettergrade (LetterGrade, Percentage) -- PossiblePoints Table (No changes needed, already in 1NF) possiblepoints (SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total) Note: Split into two tables: StudentProfile: Contains unique student data with a primary key StudentId. LabGrades: Stores each student's grade for each lab individually, with StudentId as a foreign key and LabNumber as a unique composite primary key. 2NF: -- StudentProfile Table (already in 2NF) studentprofile (StudentId*, StudentName, SP, Total, Final, IP) -- LabGrades Table (already in 2NF) labgrades (StudentId@, LabNumber*, Grade) -- LetterGrade Table (already in 2NF) lettergrade (LetterGrade, Percentage) -- PossiblePoints Table (already in 2NF) possiblepoints (SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total) Note: No changes are necessary since all the tables pass 2NF as they are. 3NF: -- StudentProfile Table (modified to remove calculated fields) studentprofile (StudentId*, StudentName, SP) -- LabGrades Table (no changes) labgrades (StudentId@, LabNumber*, Grade) -- LetterGrade Table (no changes) lettergrade (LetterGrade, Percentage) -- PossiblePoints Table (no changes) possiblepoints (SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total) Note: 1. Removed calculated fields (Total, Final, IP) from StudentProfile. These will now be dynamically calculated rather than stored. 2. All other tables remain unchanged. Three data rows: studentprofile: StudentId* StudentName SP 84228748 Lael Abbott 4 44107438 Bruce Acosta 5 21479092 Coby Fox 5 labgrades: StudentId@ LabNumber* Grade 84228748 1 10 84228748 2 5 84228748 3 9 lettergrade: LetterGrade Percentage A 93 A- 90 B+ 87 possiblepoints: SP Lab01 Lab02 Lab03 Lab04 Lab05 Lab06 Lab07 Lab08 Lab09 Total 5 10 5 10 10 15 10 15 15 15 110