| 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/20255/CST1600/41/15670648/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: - Repeating fields were removed (like Lab01–Lab09, LetterGrade1–9). - Created new tables to hold this repeating data. Students (StudentId*, StudentName) Grades (StudentId@, AssignmentName*, Score) → This replaces Lab01–Lab09. FinalGrades (StudentId@*, Total, Final, IP) LetterGrades (LetterGrade*, Percentage) PossiblePoints (AssignmentName*, MaxPoints) 2NF: - All non-key fields depend on the whole primary key in each table. - No changes needed. 3NF: - No transitive dependencies. Three data rows: Students 1, Alice Johnson 2, Ben Torres 3, Clara Liu Grades 1, SP, 10 1, Lab01, 9 1, Lab02, 10 2, SP, 8 2, Lab01, 7 2, Lab02, 6 3, SP, 10 3, Lab01, 9 3, Lab02, 10 FinalGrades 1, 180, B, B 2, 160, C, C 3, 185, A, A LetterGrades A, 90 B, 80 C, 70 D, 60 F, 0 PossiblePoints SP, 10 Lab01, 10 Lab02, 10 Lab03, 10 Lab04, 10 Lab05, 10 Lab06, 10 Lab07, 10 Lab08, 10 Lab09, 10 Total, 100