| 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/16317500/Lab09/ |
Upload File : |
* (asterisk) to denote a primary key field.
@ (at sign) to denote a foreign key field.
^ (caret) to denote a unique field that is not a primary key.
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)
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 / PointsPossible ).
IP (IIn progressP) Grade is the letter grade for student ( total points / PointsPossible of graded labs ).
Total, Final, and IP are calculated fields.
1NF:
Student(StudentId*, StudentFirstName, StudentLastName)
84228748, Lael, Abbot
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
Assignments(Labs*)
SP
Lab01
Lab02
Lab03
Lab04
Lab05
Lab06
Lab07
Lab08
Lab09
Total
LetterGrades(Letters*, LetterRequirements)
A, 93
A-, 90
B+, 87
B, 83
B-, 80
C+, 77
C, 73
C-, 70
F, 0
PointsPossible(Labs*@, MaxPoints)
SP, 5
Lab01, 10
Lab02, 5
Lab03, 10
Lab04, 10
Lab05, 15
Lab06, 10
Lab07, 15
Lab08, 15
Lab09, 15
Total, 110
Scores (StudentId*@, Labs*@, Score)
84228748, SP, 4
84228748, Lab01, 10
84228748, Lab02, 5
84228748, Lab03, 9
84228748, Lab04,
84228748, Lab05, 3
84228748, Lab06, 10
84228748, Lab07,
84228748, Lab08,
84228748, Lab09,
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,
21479092, SP, 5
21479092, Lab01, 10
21479092, Lab02, 5
21479092, Lab03, 10
21479092, Lab04, 10
21479092, Lab05, 15
21479092, Lab06, 10
21479092, Lab07,
21479092, Lab08,
21479092, Lab09,
42683650, SP, 5
42683650, Lab01, 10
42683650, Lab02, 5
42683650, Lab03, 10
42683650, Lab04, 10
42683650, Lab05, 14
42683650, Lab06, 10
42683650, Lab07,
42683650, Lab08,
42683650, Lab09,
83681840, SP, 5
83681840, Lab01, 10
83681840, Lab02, 5
83681840, Lab03, 9
83681840, Lab04, 10
83681840, Lab05,
83681840, Lab06,
83681840, Lab07,
83681840, Lab08,
83681840, Lab09,
40208573, SP, 5
40208573, Lab01, 10
40208573, Lab02, 5
40208573, Lab03,
40208573, Lab04,
40208573, Lab05,
40208573, Lab06,
40208573, Lab07, 15
40208573, Lab08,
40208573, Lab09,
83312932, SP, 5
83312932, Lab01, 10
83312932, Lab02, 5
83312932, Lab03,
83312932, Lab04,
83312932, Lab05,
83312932, Lab06,
83312932, Lab07,
83312932, Lab08,
83312932, Lab09,
34673656, SP, 5
34673656, Lab01, 10
34673656, Lab02, 5
34673656, Lab03, 8
34673656, Lab04, 2
34673656, Lab05,
34673656, Lab06,
34673656, Lab07,
34673656, Lab08,
34673656, Lab09,
98159249, SP, 5
98159249, Lab01, 10
98159249, Lab02, 5
98159249, Lab03, 10
98159249, Lab04, 10
98159249, Lab05, 15
98159249, Lab06, 10
98159249, Lab07,
98159249, Lab08,
98159249, Lab09,
94086534, SP, 5
94086534, Lab01, 10
94086534, Lab02, 5
94086534, Lab03, 10
94086534, Lab04, 10
94086534, Lab05, 15
94086534, Lab06, 10
94086534, Lab07,
94086534, Lab08,
94086534, Lab09,
25357066, SP, 5
25357066, Lab01, 10
25357066, Lab02, 5
25357066, Lab03,
25357066, Lab04, 10
25357066, Lab05,
25357066, Lab06, 10
25357066, Lab07,
25357066, Lab08,
25357066, Lab09,
55593577, SP, 5
55593577, Lab01, 10
55593577, Lab02, 5
55593577, Lab03, 10
55593577, Lab04, 10
55593577, Lab05, 5
55593577, Lab06, 10
55593577, Lab07,
55593577, Lab08,
55593577, Lab09,
12755860, SP, 5
12755860, Lab01, 7
12755860, Lab02,
12755860, Lab03,
12755860, Lab04,
12755860, Lab05,
12755860, Lab06,
12755860, Lab07, 12
12755860, Lab08,
12755860, Lab09,
99496218, SP, 5
99496218, Lab01, 10
99496218, Lab02, 5
99496218, Lab03, 9
99496218, Lab04, 4
99496218, Lab05,
99496218, Lab06,
99496218, Lab07,
99496218, Lab08,
99496218, Lab09,
49622000, SP, 5
49622000, Lab01, 5
49622000, Lab02, 5
49622000, Lab03, 9
49622000, Lab04, 10
49622000, Lab05, 3
49622000, Lab06, 10
49622000, Lab07,
49622000, Lab08,
49622000, Lab09,
1NF Notes: I had an incredible amount of difficulty figuring out exactly what to do for the calculated fields. The way I handled it was by assuming that it was to be calculated in SQL and leaving it alone for the most part, resulting in the tables there. I have a table for the students grades individually, a table for the points possible and a very iffy table I wasn't certain on putting in that includes the grading scale.
2NF: OK
3NF: OK
Three data rows:
StudentID, StudentFirstName, StudentLastName, SP Lab1, Lab2, Lab3, Lab4, Lab5, Lab6, Lab7, Lab8, Lab9, Total, Final, IIP
84228748, Lael, Abbott, 4, 10, 5, 9, 3, 10, 41, F, F
44107438, Bruce, Acosta, 5, 10, 5, 10, 10 15, 10, 15, 15, 95, B-, A
21479092, Coby, Fox, 5, 10, 5, 10, 10 15, 10, 65, F, A