| 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/16411022/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: Created grades table with StudentID as primary key and a score value. Renamed studentgrades table to student table. Removed repeating groups for assignment names by creating AssignmentID and placing it in possiblepoints as primary key and grades as foreign key, while assinging SP and all the labs an ID, while also associating each ID with an MaxPoints value. In the lettergrade table, I created GradeID as a primary key to remove groups by assigning each letter grade and their respective percentage an ID. I also placed GradeID in grades as a foreign key. student table: StudentID*, StudentName, AssignmentID@, GradeID@, Total, Final, IP grades table: StudentID*@, AssignmentID*@, Score, GradeID@ lettergrade table: GradeID*, LetterGrade, Percentage possiblepoints table: AssignmentID*, AssignmentName, MaxPoints* 2NF: OK 3NF: OK Three data rows: student table: StudentID* StudentName Total Final IP 84228748 Lael Abbott 4 F F 84228748 Lael Abbott 14 F F 84228748 Lael Abbott 19 F F grades table StudentID*@ AssignmentID@ Score GradeID@ 84228748 1 4 4 84228748 2 10 1 84228748 3 5 1 lettergrade table: GradeID* LetterGrade Percentage 1 A 93 2 A- 90 3 B+ 87 4 B 83 5 B- 80 6 C+ 77 7 C 73 8 C- 70 9 F 0 possiblepoints table: AssignmentID* AssignmentName MaxPoints 1 SP 5 2 Lab01 10 3 Lab02 5 4 Lab03 10 5 Lab04 10 6 Lab05 15 7 Lab06 10 8 Lab07 15 9 Lab08 15 10 Lab09 15 11 Total 110