| 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/11365835/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)
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
1NF:
Student_Grades
Student_ID* Student_Name SP Lab_Number* Lab_Score Total Final IP
84228748 Lael Abbott 4 01 10 41 F F
84228748 Lael Abbott 4 02 5 41 F F
84228748 Lael Abbott 4 03 9 41 F F
84228748 Lael Abbott 4 04 ns 41 F F
84228748 Lael Abbott 4 05 3 41 F F
84228748 Lael Abbott 4 06 10 41 F F
84228748 Lael Abbott 4 07 ns 41 F F
84228748 Lael Abbott 4 08 ns 41 F F
84228748 Lael Abbott 4 09 ns 41 F F
44107438 Bruce Acosta 5 01 10 95 B- A
44107438 Bruce Acosta 5 02 5 95 B- A
44107438 Bruce Acosta 5 03 10 95 B- A
44107438 Bruce Acosta 5 04 10 95 B- A
44107438 Bruce Acosta 5 05 15 95 B- A
44107438 Bruce Acosta 5 06 10 95 B- A
44107438 Bruce Acosta 5 07 15 95 B- A
44107438 Bruce Acosta 5 08 15 95 B- A
44107438 Bruce Acosta 5 09 ns 95 B- A
21479092 Coby Fox 5 01 10 65 F A
21479092 Coby Fox 5 02 5 65 F A
21479092 Coby Fox 5 03 10 65 F A
21479092 Coby Fox 5 04 10 65 F A
21479092 Coby Fox 5 05 15 65 F A
21479092 Coby Fox 5 06 10 65 F A
21479092 Coby Fox 5 07 ng 65 F A
21479092 Coby Fox 5 08 ns 65 F A
21479092 Coby Fox 5 09 ns 65 F A
Table Changes: Created columns for lab numbers and scores.
2NF:
Student
Student_ID* Student_Name
84228748 Lael Abbott
44107438 Bruce Acosta
21479092 Coby Fox
Student_Grades
Student_ID* SP Lab_Number* Lab_Score Total Final IP
84228748 4 01 10 41 F F
84228748 4 02 5 41 F F
84228748 4 03 9 41 F F
84228748 4 04 ns 41 F F
84228748 4 05 3 41 F F
84228748 4 06 10 41 F F
84228748 4 07 ns 41 F F
84228748 4 08 ns 41 F F
84228748 4 09 ns 41 F F
44107438 5 01 10 95 B- A
44107438 5 02 5 95 B- A
44107438 5 03 10 95 B- A
44107438 5 04 10 95 B- A
44107438 5 05 15 95 B- A
44107438 5 06 10 95 B- A
44107438 5 07 15 95 B- A
44107438 5 08 15 95 B- A
44107438 5 09 ns 95 B- A
21479092 5 01 10 65 F A
21479092 5 02 5 65 F A
21479092 5 03 10 65 F A
21479092 5 04 10 65 F A
21479092 5 05 15 65 F A
21479092 5 06 10 65 F A
21479092 5 07 ng 65 F A
21479092 5 08 ns 65 F A
21479092 5 09 ns 65 F A
Grading_Scale
Letter_Grade Grade_Percentage
A 93
A- 90
B+ 87
B 83
B- 80
C+ 77
C 73
C- 70
F 0
Possible_Points
SP Lab01 Lab02 Lab03 Lab04 Lab05 Lab06 Lab07 Lab08 Lab09 Total
5 10 5 10 10 15 10 15 15 15 110
Table Changes: Created tables for grading scale, and possible points for assignments. Also, created a table for student information.
3NF:
Okay
Three data rows:
Student_Grades
Student_ID* SP Lab_Number* Lab_Score Total Final IP
84228748 4 01 10 41 F F
84228748 4 02 5 41 F F
84228748 4 03 9 41 F F
Grading_Scale
Letter_Grade Grade_Percentage
A 93
A- 90
B+ 87
B 83
B- 80
C+ 77
C 73
C- 70
F 0
Possible_Points
SP Lab01 Lab02 Lab03 Lab04 Lab05 Lab06 Lab07 Lab08 Lab09 Total
5 10 5 10 10 15 10 15 15 15 110