| 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/00071476/Lab09/ |
Upload File : |
StudentId is a unique ID number assigned to the student.
StudentName is the student's full name.
SP is the student's grade for the Student Profile.
Lab01, Lab02, Lab03, etc are the student's grades for those labs.
Final is the student's final grade if no more work is done.
IP is the student's grade for the work that has been performed.
The lettergrade table field meanings are:
LetterGrade1, LetterGrade2, LetterGrade3, etc are the letter grades that would be given when a percentage is met.
Percentage1, Percentage2, Percentage3, etc are the percentages that must be met to obtain that letter grade.
The possiblepoints table field meanings are:
SP, Lab01, Lab02, etc are the max points possible for those assignments.
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:
studentgrades (StudentId*, StudentFirstName, StudentLastName, AssignmentType, AssignmentNumber, Grade)
lettergrade (StudentId@*, LetterGrade, Percentage)
possiblepoints (StudentId@*, AssignmentType@*, AssignmentNumber, MaxPoints)
Notes:
StudentGrades:
Separated StudentName into StudentFirstName and StudentLastName.
Introduced AssignmentType and AssignmentNumber columns to represent the different types of assignments (e.g., SP, Lab01, Lab02).
Each row now represents a single assignment for a student.
LetterGrade:
Simplified the structure to have only two columns: LetterGrade and Percentage.
This allows for a more straightforward representation of letter grades and their corresponding percentages.
PossiblePoints:
Similar to StudentGrades, introduced AssignmentType and AssignmentNumber columns.
Represents the maximum points possible for each assignment type.
2NF:
student (StudentId*, StudentFirstName, StudentLastName)
assignment (AssignmentType*, AssignmentNumber)
lettergrade (StudentId@*, LetterGrade, Percentage)
possiblepoints (StudentId@*, AssignmentType@*, AssignmentNumber, MaxPoints)
Notes:
Table assignment was introduced to separate information about student and the assignments.
information on the assignments were removed from the studentgrade table, which was renamed to student table.
3NF:
student (StudentId*, StudentFirstName, StudentLastName)
OK
assignment (AssignmentNumber, AssignmentType*, MaxPoints)
studentgrade (StudentId@*, AssignmentNumber, pointsEarned)
Notes:
The information about assignments and their possible points was originally split between the "assignment" and "possiblepoints" tables.
In 3NF, I combined this information into the "assignment" table, which now includes columns for "AssignmentNumber," "AssignmentType,"
and "MaxPoints." This consolidation helps eliminate redundancy and ensures that information about assignments is stored in a single table.
The "lettergrade" table was renamed to "studentgrade," .
Three data rows:
student (StudentId*, StudentFirstName, StudentLastName)
84228748 Lael Abbott
44107438 Bruce Acosta
21479092 Coby Fox
assignment (AssignmentNumber, AssignmentType*, MaxPoints)
1 SP 5
2 Lab01 10
3 Lab02 5
4 Lab03 10
5 Lab04 10
6 Lab05 15
7 Lab06 10
8 Lab07 15
9 Lab08 15
10 Lab09 15
studentgrade ( StudentId@*, AssignmentNumber@*, pointsEarned)
84228748 1 5
84228748 2 9
84228748 3 ns
84228748 4 3
84228748 5 10
84228748 6 ns
84228748 7 ns
84228748 8 ns
84228748 9 ns
84228748 10 ns
44107438 1 5
44107438 2 10
44107438 3 5
44107438 4 10
44107438 5 10
44107438 6 15
44107438 7 10
44107438 8 15
44107438 9 15
44107438 10 ns
21479092 1 5
21479092 2 10
21479092 3 5
21479092 4 10
21479092 5 10
21479092 6 15
21479092 7 10
21479092 8 ng
21479092 9 ns
21479092 10 ns