| 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/16917479/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: 2NF: 3NF: 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*, StudentName, Assignment, Grade) lettergrade (LetterGrade*, Percentage) possiblepoints (Assignment*, MaxPoints) Notes: - **Violations of 1NF:** - Repeating fields such as `Lab01, Lab02, Lab03...` in `studentgrades` and `possiblepoints`. - Multiple fields for letter grades (`LetterGrade1, LetterGrade2...`) in `lettergrade`. - **New fields/tables created:** - `Assignment`: Represents individual assignments such as SP, Lab01, Lab02, etc. - `Grade`: Stores the grade for a specific assignment and student. - `MaxPoints`: Maximum possible points for an assignment. - **Tables created:** - `studentgrades`: To normalize assignment grades per student. - `lettergrade`: To store letter grades and their corresponding percentages in atomic form. - `possiblepoints`: To store the maximum possible points for each assignment. - **Renamed fields:** - `Lab01`, `Lab02`, etc., collapsed into `Assignment` to simplify structure. 2NF: students (StudentId*, StudentName) grades (StudentId*@students.StudentId, Assignment*@possiblepoints.Assignment, Grade) possiblepoints (Assignment*, MaxPoints) lettergrade (LetterGrade*, Percentage) Notes: - **Violations of 2NF:** - Partial dependency in `studentgrades` and `lettergrade`. For example, `StudentName` depends only on `StudentId`, not the composite key. - **Tables created:** - `students`: To store student-specific information. - `grades`: To manage assignment grades for each student and eliminate redundancy. - **Fields created:** - None; all fields are reorganized. - **Fields renamed:** - None; only tables reorganized. 3NF: students (StudentId*, StudentName) assignments (Assignment*, MaxPoints) grades (StudentId*@students.StudentId, Assignment*@assignments.Assignment, Grade) lettergrades (LetterGrade*, Percentage) Notes: - **Violations of 3NF:** - Transitive dependency existed in `studentgrades` where `MaxPoints` was dependent on `Assignment`. - **Tables created:** - `assignments`: To store assignment details, separating assignment-specific data (`MaxPoints`). - `lettergrades`: To normalize letter grade and percentage data. - **Fields created:** - None; the existing fields are normalized. - **Fields renamed:** - `possiblepoints` table renamed to `assignments` to reflect its purpose. Three data rows: 1. `students` table: StudentId | StudentName ------------------------ 1 | John Doe 2 | Jane Smith 2. `assignments` table: Assignment | MaxPoints ----------------------- SP | 10 Lab01 | 15 3. `grades` table: StudentId | Assignment | Grade ------------------------------ 1 | SP | 9 1 | Lab01 | 14 2 | SP | 8 4. `lettergrades` table: LetterGrade | Percentage ------------------------- A | 90 B | 80 C | 70