| 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/15706840/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:
the most obvious violations of first normal form are all of the repeating values. in the studentgrades table all of the labs are listed individually, as well as the letter grades and percentages in the lettergrade table, and the assignments in the possible points table. i separated the different assignments into their own table called assignments, which has the name of the assignment and the possible score for that assignment in it. then i separated the grades into two tables, one of the tables has the students scores for each individual assignement, and the other has the different grades for each student (total points, final and in progress grade). the last table stores the letter grades and the percentages required to achieve them.
students ( studentID*, studentName )
assignments ( assignmentName* , maxPoints )
scores( studentID*@ , assignmentName*@, score )
grades ( studentID*@ , total , final , IP )
letterGrades ( letter* , percent )
2NF:
these tables pass 2nf because there is only one table with a composite key, and the score value depends on both the student and the assignment
3NF:
these tables pass 3nf because all the values are dependent only on the primary key
Three data rows:
students (studentID* studentName )
84228748 Lael Abbott
44107438 Bruce Acosta
21479092 Coby Fox
assignments (assignmentName* maxPoints )
SP 5
Lab01 10
Lab02 5
scores (studentID*@ assignmentName*@ score )
84228748 SP 4
84228748 Lab01 10
84228748 Lab02 5
grades (studentID*@ total final IP )
84228748 41 F F
44107438 95 B- A
21479092 65 F A
letterGrades (letter percent )
A 93
A- 90
B+ 87
Sample data in table form:
studentgrades (StudentId*, StudentName, SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total, Final, IP)
84228748, Lael Abbott, 4, 10, 5, 9, ns, 3, 10, ns, ns, ns, 41, F, F
44107438, Bruce Acosta, 5, 10, 5, 10, 10 15, 10, 15, 15, ns, 95, B-, A
21479092, Coby Fox, 5, 10, 5, 10, 10 15, 10, ng, ns, ns, 65, F, A
42683650, Mira Gentry, 5, 10, 5, 10, 10 14, 10, ns, ns, ns, 64, F, A
83681840, Hayes Gibson, 5, 10, 5, 9, 10 ns, ns, ns, ns, ns, 39, F, C-
40208573, Ethan Gomez, 5, 10, 5, ns, ns ns, ns, 15, ns, ns, 35, F, F
83312932, Xerxes Hayes, 5, 10, 5, ns, ns ns, ns, ns, ns, ns, 20, F, F
34673656, Avram Hinton, 5, 10, 5, 8, 2 ns, ns, ns, ns, ns, 30, F, F
98159249, Caleb Madden, 5, 10, 5, 10, 10 15, 10, ng, ns, ns, 65, F, A
94086534, Kristen Maxwell, 5, 10, 5, 10, 10 15, 10, ng, ns, ns, 65, F, A
25357066, Amos McCarthy, 5, 10, 5, ng, 10 ns, 10, ng, ns, ns, 40, F, C
55593577, Harper Mcmahon, 5, 10, 5, 10, 10, 5, 10, ng, ns, ns, 55, F, B
12755860, Nissim Moreno, 5, 7, ns, ns, ns ns, ns, 12, ns, ns, 24, F, F
99496218, Jena Sosa, 5, 10, 5, 9, 4 ns, ns, ns, ns, ns, 33, F, F
49622000, Colette Valentine, 5, 5, 5, 9, 10, 3, 10, ns, ns, ns, 47, F, C-
lettergrade (LetterGrade1, Percentage1, LetterGrade2, Percentage2, LetterGrade3, Percentage3, LetterGrade4, Percentage4, LetterGrade5, Percentage5, LetterGrade6, Percentage6, LetterGrade7, Percentage7, LetterGrade8, Percentage8, LetterGrade9, Percentage9)
A, 93, A-, 90, B+, 87, B, 83, B-, 80, C+, 77, C, 73, C-, 70, F, 0
possiblepoints (SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total)
5, 10, 5, 10, 10, 15, 10, 15, 15, 15, 110
Data information:
SP is the point grade for the student's profile.
Lab01 thru Lab09 is the point grade each student has received for that lab.
ng = not graded.
ns = not submitted.
You need not store ng or ns grades as they are calculated.
Total is the total points the student has.
Final is the letter grade for student ( total points / Total points ).
IP (IIn progressP) Grade is the letter grade for student ( total points / total points of graded labs ).
Total, Final, and IP are calculated fields.