| 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/20245/CST1600/41/16574034/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: student(StudentId*, StudentName, SP) studentAssignmentGrades(assignmentId*, StudentId@, Lab, percentageGrade^) letterGrade(assignmentId@, StudentId@, Lab, percentageGrade^, letterGrade) possiblePoints(StudentId@, assignemntId@, Lab, SP) 2NF: Ok 3NF: Ok Three data rows: student StudentId StudentName SP 212 George Lee 5 189 Mary Lou 5 143 Max Willis 4 studentAssignemtnGrades assignmentId studentId Lab percentageGrade 231 143 8 80% 412 212 10 100% 111 212 7 70% letterGrade assignmentId StudentId Lab letterGrade 231 143 8 B 412 212 10 A 111 212 7 C possiblePoints StudentId assignemtnId Lab SP 143 231 8 4 212 412 10 5 212 111 7 3