| 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 : /nginx/html/uploads/20243/CST1600/41/00103226/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*, FirstName, LastName) lettergrade (Grade*, Percentage) assignmentMax (Assignment*, MaxPoints) studentgrade (StudentId*, Assignment, PointsEarned) studentFinalGrade (StudentId*, FinalGrade) studentProgressGrade (StudentId*, InProgressGrade) Got rid of a bunch of repeating fields/information. As with our other normalization assignments, student table consists of an ID and first/last name fields. The lettergrade table shows the grade and the percentage range of that particular grade. assignmentMax shows the maximum available points for each assignment, with assignment being the primary key. studentgrade shows the points earned for each assignment. studentFinalGrade shows the final grade with the student ID, and similarily, the studentProgressGrade shows the in-progress grade along with a student ID. 2NF: OK 3NF: student (StudentId*, FirstName, LastName) lettergrade (Grade*, Percentage) assignmentMax (Assignment*, MaxPoints) studentgrade (StudentId*@, Assignment*@, PointsEarned) studentFinalGrade (StudentId*, FinalGrade) studentProgressGrade (StudentId*, InProgressGrade) Making the studentgrade table have both StudentId* and Assignment* be composite primary keys. Three data rows: student ( StudentId*, FirstName, LastName) 84228748, Lael, Abbott 44107438, Bruce, Acosta 21479092, Coby, Fox lettergrade (Grade*, Percentage) A, 93 A-, 90 B+, 87 B, 83 B-, 80 C+, 77 C, 73 C-, 70 F, 0 assignmentMax (Assignment*, MaxPoints) SP, 5 Lab01, 10 Lab02, 5 Lab03, 10 Lab04, 10 Lab05, 15 Lab06, 10 Lab07, 15 Lab08, 15 Lab09, 15 Total 110 studentgrade (StudentId*@, Assignment*@, PointsEarned) 84228748, SP, 4 84228748, Lab01, 10 84228748, Lab02, 5 84228748, Lab03, 9 84228748, Lab04, NULL 84228748, Lab05, 3 84228748, Lab06, 10 84228748, Lab07, NULL 84228748, Lab08, NULL 84228748, Lab09, NULL 84228748, Total, 41 44107438, SP, 5 44107438, Lab01, 10 44107438, Lab02, 5 44107438, Lab03, 10 44107438, Lab04, 10 44107438, Lab05, 15 44107438, Lab06, 10 44107438, Lab07, 15 44107438, Lab08, 15 44107438, Lab09, NULL 44107438, Total, 95 21479092, SP, 5 21479092, Lab01, 10 21479092, Lab02, 5 21479092, Lab03, 10 21479092, Lab04, 10 21479092, Lab05, 15 21479092, Lab06, 10 21479092, Lab07, NULL 21479092, Lab08, NULL 21479092, Lab09, NULL 21479092, Total, 65 studentFinalGrade (StudentId*, FinalGrade) 84228748, F 44107438, B- 21479092, F studentProgressGrade ( StudentId*, InProgressGrade) 84228748, F 44107438, A 21479092, A