| 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/20253/CST1600/41/16843769/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:
Notes:
1) put an s in front of student scores to show the difference from possible points
2)studentgrades total will now be studentTotal
3) student_id is jest comparing studentTotal to lettergrade
Making letterGrade into one value and doing same with the percents to get the numbers in between
student_id(studentID*)
student_name(studentID*@, name)
student_points(StudentID*@, studentSP, studentLab01, studentLab02, studentLab03, studentLab04, studentLab05, studentLab06, studentLab07, studentLab08, studentLab09)
student_final(studentID*@, studentTotal*, Total*@, Final)
student_ip(studentID*@, studentTotal*, IP)
max_points(Total, SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09)
percent(letterGrade*)
letter_percent(letterGrade*@, percentGrade)
2NF:
OK
3NF:
OK
student_id(studentID*)
student_name(studentID*@, name)
student_points(StudentID*@, studentSP, studentLab01, studentLab02, studentLab03, studentLab04, studentLab05, studentLab06, studentLab07, studentLab08, studentLab09)
student_final(studentID*@, studentTotal*, Total*@, Final)
student_ip(studentID*@, studentTotal*, IP)
max_points(Total, SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09)
percent(letterGrade*)
letter_percent(letterGrade*@, percentGrade)
Three data rows:
student_id (studentID*)
84228748
44107438
21479092
42683650
83681840
40208573
83312932
34673656
98159249
94086534
25357066
55593577
12755860
99496218
49622000
student_name (studentID*@, name)
84228748, Lael Abbott
44107438, Bruce Acosta
21479092, Coby Fox
42683650, Mira Gentry
83681840, Hayes Gibson
40208573, Ethan Gomez
83312932, Xerxes Hayes
34673656, Avram Hinton
98159249, Caleb Madden
94086534, Kristen Maxwell
25357066, Amos McCarthy
55593577, Harper Mcmahon
12755860, Nissim Moreno
99496218, Jena Sosa
49622000, Colette Valentine
student_points (studentID*@, studentSP, studentLab01, studentLab02, studentLab03, studentLab04, studentLab05, studentLab06, studentLab07, studentLab08, studentLab09)
84228748, 4, 10, 5, 9, ns, 3, 10, ns, ns, ns
44107438, 5, 10, 5, 10, 10, 15, 10, 15, 15, ns
21479092, 5, 10, 5, 10, 10, 15, 10, ng, ns, ns
42683650, 5, 10, 5, 10, 10, 14, 10, ns, ns, ns
83681840, 5, 10, 5, 9, 10, ns, ns, ns, ns, ns
40208573, 5, 10, 5, ns, ns, ns, ns, 15, ns, ns
83312932, 5, 10, 5, ns, ns, ns, ns, ns, ns, ns
34673656, 5, 10, 5, 8, 2, ns, ns, ns, ns, ns
98159249, 5, 10, 5, 10, 10, 15, 10, ng, ns, ns
94086534, 5, 10, 5, 10, 10, 15, 10, ng, ns, ns
25357066, 5, 10, 5, ng, 10, ns, 10, ng, ns, ns
55593577, 5, 10, 5, 10, 10, 5, 10, ng, ns, ns
12755860, 5, 7, ns, ns, ns, ns, ns, 12, ns, ns
99496218, 5, 10, 5, 9, 4, ns, ns, ns, ns, ns
49622000, 5, 5, 5, 9, 10, 3, 10, ns, ns, ns
student_final (studentID*@, studentTotal*, Total*, Final)
84228748, 41, 110, F
44107438, 95, 110, B-
21479092 65, 110, F
42683650 64, 110, F
83681840 39, 110, F
40208573 35, 110, F
83312932 20, 110, F
34673656 30, 110, F
98159249 65, 110, F
94086534 65, 110, F
25357066 40, 110, F
55593577 55, 110, F
12755860 24, 110, F
99496218 33, 110, F
49622000 47, 110, F
student_ip ((studentID*@, studentTotal*, Total*@, IP)
84228748, 41, 110, F
44107438, 95, 110, A
21479092 65, 110, A
42683650 64, 110, A
83681840 39, 110, C-
40208573 35, 110, F
83312932 20, 110, F
34673656 30, 110, F
98159249 65, 110, A
94086534 65, 110, A
25357066 40, 110, C
55593577 55, 110, B
12755860 24, 110, F
99496218 33, 110, F
49622000 47, 110, C-
max_points (Total*, SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09)
110, 5, 10, 5, 10, 10 15, 10, 15, 15, 15
percent (letterGrade*)
A
A-
B+
B
B-
C+
C
C-
letter_percent (letterGrade*@, percentGrade)
A, 93%+
A-, 90%+
B+, 87%+
B, 83%+
B-, 80%+
C+, 77%+
C, 73%+
C-, 70%+
F, <70%