| 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/15650461/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:
First we need to create a student table with the studentId as the primary key and first name and last name as added fields. I renamed possiblepoints to labs with a labId as a primary key and lab name and possible points for each lab. We'd make a points table using the two foriegn keys studentId and labId as the composite primary key and for each lab the points the student got on each particular lab. I renamed lettergrade to letter_grade table to specify the beginning and end percentages for each grade.
I don't think we're supposed to store calculated data in the database, so I'm assuming a query would be run to total all the labs and each students points and divide the student by the possible points to calculate the in progress and final grades. Another query would be run to calculate the percentage and then use the letter_grade table to assign a grade based on that percentage.
student(studentId*, studentFirstName^, studentLastName^)
labs(labId*, labName^, labPossiblePoints^)
points(studentId@, labId@, labPoints^)
letter_grade(letterGradeId*, highPercent^, lowPercent^, letterGrade^)
2NF:
OK
3NF:
OK
Three data rows:
student(studentId*, studentFirstName^, studentLastName^)
84228748, Lael, Abbott
44107438, Bruce, Acosta
21479092, Coby, Fox
labs(labId*, labName^, labPossiblePoints^)
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
points(studentId@, labId@, labPoints^)
84228748, 1, 4
84228748, 2, 10
84228748, 3, 5
44107438, 1, 5
44107438, 2, 10
44107438, 3, 5
21479092, 1, 5
21479092, 2, 10
21479092, 3, 5
letter_grade(letterGradeId*, highPercent^, lowPercent^, letterGrade^)
1, 100, 93, A
2, 92, 90, A-
3, 89, 87, B+
4, 86, 83, B
5, 82, 80, B-
6, 79, 77, C+
7, 76, 73, C
8, 72, 70, C-
9, 69, 0, F