| 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/14709590/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: no changes
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: no changes
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: no changes
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:
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 Valentine5 5 5 9 10 3 10 ns ns ns 47 F C-
}
lettergrade {
LG1 P1 LG2 P2 LG3 P3 LG4 P4 LG5 P5 LG6 P6 LG7 P7 LG8 P8 LG9 P9
A 93 A- 90 B+ 87 B 83 B- 80 C+ 77 C 73 C- 70 F 0
}
possiblepoints {
SP L1 L2 L3 L4 L5 L6 L7 L8 L9 Total
5 10 5 10 10 15 10 15 15 15 110
}