| 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/JimMartinson/Classes/CST1600/Labs/ |
Upload File : |
Lab 8 - 2nd Normalization
Grading Criteria
Total possible points: 15
-15 1NF violation. Further grading will not be done.
-4 2NF violation.
-3 3NF violation.
-4 Data loss (Data not in tables or relationship between data is lost).
-4 Deletion anomaly.
-3 Insert or update anomaly.
-3 No primary key. You did not designate a PK for this table.
-2 Incorrect primary key.
-2 Duplication of data (not covered by an insert or update anomaly).
-1 Duplication of table for same data type.
-1 Incorrect foreign key.
-1 Incorrect unique field.
-1 Bad table or field name.
-1 New or renamed field not listed under Table field meanings are section.
-2 Table in Three data rows section does not match table in 3NF section.
-1 Data incorrect in Three data rows section.
There are some things I expect. If they are incorrect you will lose the following:
Work submitted incorrectly: -2 pts. This covers errors such as incorrect files names, incorrect file formats, poor formatting, etc.
Second and subsequent submission of work for grading: -2 pts.
Work submitted late: -2 pts per week.
I reserve the right not to apply the deduction points at my absolute discretion.
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)
-2 All of the data fields are calculated and should not be stored.
1NF:
2NF:
3NF:
student (studentId*, studentFirstName, studentLastName)
studentGrade (studentId*@, assignmentId*@, receivedPoints)
letterGrade (letterGrade*, percentage)
assignment (assignmentId*, assignmentTitle, assignmentPoints)
studentFinalGrade (studentId*@, recievedTotal, Final, IP)
-5 1NF violation. studentName is non-atomic.
student(studentID*, studentName^)
-5 1NF violation.
The `StudentName` field is non-atomic. It holds a first and last name.
-5 1NF violation. studentName is non-atomic. It also should not be set to unique.
Studentgrades(studentID*, SP, Final, IP, Total)
-5 1NF violation. Repeating fields.
SP, Lab01, Lab02, etc. are the same type of data and should be stored in another table.
The they should be related by FK to the student with their grade in another table.
-5 1NF violation. Repeating fields.
The letter grade and percentage need to be stored in a table with only `LetterGrade` and `Percentage` as fields.
-5 1NF violation. Repeating fields.
SP, Lab01, Lab02, etc. are the same type of data.
This should be stored in a table with a field to hold the assignment name, and one to hold the possible points.
-2 Storing calculated fields.
Total, Final, and IP are calculated fields and should not be stored.
-2 Storing calculated fields. All of the data fields are calculated and should not be stored.
labPoints(labNumber*, totalLabPoints)
-4 Data loss. The lab names are lost and SP is not stored at all.
studentLabs(studentID*, labNumber*@, labGrade)
-4 Data loss. The points the student recieved for the lab are not stored.
Also, labGrade is calculated.
-4 Data loss (Data not in tables or relationship between data is lost).
You do not have a table to store the letter grades and percentages.
Other:
-4 Data loss. You do not store the points needed for a letter grade.
studentgrades ( StudentId*, studentFirstName, studentLastName, Final@, IP)
-2 Storing calculated fields.
The Final and IP grades are calculated and should not be stored.
lettergrade(lettergrade*, percentage)
OK.
possiblepoints( Labs*, possiblepoints*@)
OK.
Other:
-10 Data loss.
None of the data for the student assignment grades are stored.
=e
Three data rows:
Three data rows:
-2 The first three rows from the studentgrades table is needed.
-2 All the data from the lettergrade table is needed.
-2 All the data from the possiblepoints table is needed.