| 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/20243/CST1600/41/16414553/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:
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)
2NF:
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)
3NF:
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)
Three data rows:
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.