| 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/20245/CST1600/41/10970913/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:
Note: For 1NF, i had to ensure there were no repeating groups or calculated fields stored.
CREATE TABLE studentgrades (
StudentId INT PRIMARY KEY,
StudentName VARCHAR(100),
SP INT,
Lab01 INT,
Lab02 INT,
Lab03 INT,
Lab04 INT,
Lab05 INT,
Lab06 INT,
Lab07 INT,
Lab08 INT,
Lab09 INT,
Final VARCHAR(5),
IP VARCHAR(5)
);
CREATE TABLE lettergrades (
LetterGradeId INT PRIMARY KEY AUTO_INCREMENT,
LetterGrade VARCHAR(2),
Percentage INT
);
CREATE TABLE possiblepoints (
Assignment VARCHAR(10) PRIMARY KEY,
Points INT
);
Notes: In studentgrades I removed the Total field since it is a calculated value and not required to be stored.
In lettergrade I Converted the repeating groups into a single table structure
=======================================================================================================
2NF:
For 2NF, the tables remain unchanged since I removed partial dependencies during the 1NF stage.
Notes:
studentgrades: Already in 2NF as no partial dependencies exist as each attribute fully depends on the primary key StudentId.
lettergrades: Already in 2NF as LetterGrade and Percentage fully depend on LetterGradeId.
possiblepoints: Already in 2NF as Points fully depends on Assignment.
=======================================================================================================
3NF:
Same as 2NF
studentgrades: Has no transitive dependencies because all fields depend only on the primary key.
lettergrades: Has no transitive dependencies either as each field depends only on the primary key.
possiblepoints: Points depends only on Assignment so same as the others there should be no transitive dependencies