| 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/16316941/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)
note: student first name and last need to be seperate, letter grade and percentage are seperated data that could fit under a
single colunm. labs are reapeating data and can be seperate with score. totals, final, and IP are calaculated fields
1NF:studentgrades (StudentId*, StudentFirstName, StudentLastName, Lab*, Score)
lettergrade (LetterGrade*, Percentage)
possiblepoints (Lab*, Possible)
note: OK
2NF:studentgrades (StudentId*, StudentFirstName, StudentLastName, Lab*, Score)
lettergrade (LetterGrade*, Percentage)
possiblepoints (Lab*@, Possible)
note: student iformation and grades can be seperate,
3NF:students (StudentId*, StudentFirstName, StudentLastName)
studentgrades(StudentId*@, Lab*, Score)
lettergrade (LetterGrade*, Percentage)
possiblepoints (Lab*@, Possible)
Three data rows:
students (StudentId*, StudentFirstName, StudentLastName)
84228748, Lael, Abbott
44107438, Bruce, Acosta
21479092, Coby, Fox
studentgrades(StudentId*@, Lab*, Score)
84228748, SP, 4
84228748, lab01, 10
84228748, lab02, 5
84228748, lab03, 9
84228748, lab04, ns
84228748, lab05, 3
84228748, lab06, 10
84228748, lab07, ns
84228748, lab08, ns
84228748, lab09, ns
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, ns
21479092, SP, 5
21479092, lab01, 10
21479092, lab02, 5
21479092, lab03, 10
21479092, lab04, 10
21479092, lab05, 15
21479092, lab06, 10
21479092, lab07, ng
21479092, lab08, ns
21479092, lab09, ns
lettergrade (LetterGrade*, Percentage)
A, 93
A-, 90
B+, 87
B, 83
B-, 80
C+, 77
C, 73
C-, 70
F, 0
possiblepoints (Lab*@, Possible)
SP, 5
lab01, 10
lab02, 5
lab03, 10
lab04, 10
lab05, 15
lab06, 10
lab07, 15
lab08, 15
lab09, 15
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.