GIF89a; %PDF-1.5 %���� ºaâÚÎΞ-ÌE1ÍØÄ÷{òò2ÿ ÛÖ^ÔÀá TÎ{¦?§®¥kuµù Õ5sLOšuY Donat Was Here
DonatShell
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/16267537/Lab09/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /nginx/html/uploads/20243/CST1600/41/16267537/Lab09/StevenMorgan-Lab09.txt
UNF (Unnormalized Form):
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 (First Normal Form):
New Table: LabGrades
labgrades(StudentId@, LabNumber*, Grade)

Updated studentgrades Table:
studentgrades(StudentId*, StudentName, SP, Total, Final, IP)

Updated lettergrade Table:
lettergrade(LetterGrade*, Percentage)

Updated possiblepoints Table:
possiblepoints(LabNumber*, MaxPoints)

2NF (Second Normal Form):
New Table: LabDetails
labdetails(LabNumber*, MaxPoints)

Updated LabGrades Table:
labgrades(StudentId@, LabNumber@*, Grade)

3NF (Third Normal Form):
New Table: StudentDetails
studentdetails(StudentId*, StudentName, SP, Total, Final, IP)

Updated labgrades Table:
labgrades(StudentId@, LabNumber@*, Grade)

All Data Rows:
StudentDetails:
StudentId* | StudentName       | SP | Total | Final | IP
-----------|-------------------|----|-------|-------|----
84228748   | Lael Abbott       | 4  | 41    | F     | F
44107438   | Bruce Acosta      | 5  | 95    | B-    | A
21479092   | Coby Fox          | 5  | 65    | F     | A
... (Other student details)

LabDetails:
LabNumber* | MaxPoints
-----------|----------
Lab01      | 10
Lab02      | 5
Lab03      | 10
... (Other lab details)

LabGrades:
StudentId@ | LabNumber@ | Grade
-----------|------------|------
84228748   | Lab01      | 10
84228748   | Lab02      | 5
84228748   | Lab03      | 9
... (Other lab grades)

LetterGrade:
LetterGrade* | Percentage
-------------|-----------
A            | 93
A-           | 90
B+           | 87
... (Other letter grades)

Anon7 - 2022
AnonSec Team