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/16318726/Lab09/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/uploads/20243/CST1600/41/16318726/Lab09/LoganAnglin-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:
Note: StudentName has more than one value. Additionally, lettergrade, and possiblepoints have no primary keys.
1) I will change StudentName to two fields called studentFirstName, and studentLastName to make each one value. Also, i will give lettergrade a primary key of LetterID*. Additionally, I will give possiblepoints a primary key of PointID*
studentgrades (StudentID*, StudentFirstName, StudentLastName, SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total, Final, IP)
lettergrade (LetterID*, LetterGrade1, Percentage1, LetterGrade2, Percentage2, LetterGrade3, Percentage3, LetterGrade4, Percentage4, LetterGrade5, Percentage5, LetterGrade6, Percentage6, LetterGrade7, Percentage7, LetterGrade8, Percentage8, LetterGrade9, Percentage9)
possiblepoints (PointID*, SP, Lab01, Lab02, Lab03, Lab04, Lab05, Lab06, Lab07, Lab08, Lab09, Total)

2NF:
Note: the labs and sp of studentgrades are not directly connected to soley the studentgrades. Next there is no direct correlation with studentgrades and the fields Total, Final, and IP. Then there is a more effective way of showing possiblepoints for each Lab. Finally there is a way to make the lettergrade field more effective also.
1) I would make a assignment table with a primary key of AssignmentID* and a foreign key of StudentId@. Also, I would take the fields of all labs and sp of studentgrades to a field called Points (also am changing the table studentgrades to student).
2) I would make a table called grade with a primary key of GradeID* with a foreign key of StudentId@. Then I will move three fields from student to grade that are Total, Final, and IP.
3) I would start by getting rid of all of the Labs and SP. Then I would add a MaxPoints field and a Homework field to dictate which assignment has so many points. Also, I would get rid of the total field due to the fact that the total can be calculated from the possiblepoints table. Additionally I will add PointID@ to assignment.
4) I will start by getting rid of all of the LetterGrades and Percentages and replace them with two fields called LetterGrade and Percentage.
student (StudentID*, StudentFirstName, StudentLastName)
assignment (AssignmentID*, StudentId@, Points)
grade (GradeID*, StudentID@, Total, Final, IP)
possiblepoints (PointID*, MaxPoints, Homework)
lettergrade (LetterID*, LetterGrade, Percentage)


3NF:
OK

Three data rows:
student (StudentId*, StudentFirstName, StudentLastName)
		 84228748	 Lael 			   Abbott
		 44107438	 Bruce 			   Acosta
		 21479092	 Coby 			   Fox
		 
assignment (AssignmentID*,  StudentId@, 	PointID@, Points)		 
			1			    84228748	    1		 	4
			2			    44107438	    1		 	5
			3		        21479092	    1			5
			4			    84228748		2			10
			5			    44107438		2			10
			6				21479092   	    2 			10
			7				84228748	    3			5
			8				44107438		3			5
			9				21479092		3			5
			10				84228748		4			9
			11				44107438		4			10
			12				21479092		4			10
			13				84228748		5			ns
			14				44107438		5			10
			15				21479092		5			10
			16				84228748		6			3
			17				44107438		6			15
			18				21479092		6			15
			19				84228748		7			10
			20				44107438		7			10
			21				21479092		7			10
			22				84228748		8			ns
			23				44107438		8			15
			24				21479092		8			ng
			25				84228748		9			ns
			26				44107438		9			15
			27				21479092		9			ns
			28				84228748		10			ns
			29				44107438		10			ns
			30				21479092		10			ns
			
grade  (GradeID*,   StudentID@, Total,  Final,  IP)
		1			84228748	41		F		F
		2			44107438	95		B-		A
		3   		21479092	65		F		A
		
possiblepoints (PointID*,   MaxPoints,  Homework)
				1			5			SP
				2			10			Lab01
				3			5			Lab02
				4			10			Lab03
				5			10			Lab04
				6			15			Lab05
				7			10			Lab06
				8			15			Lab07
				9			15			Lab08
				10			15			Lab09
				
lettergrade    (LetterID*,  LetterGrade, 	Percentage)
				1			A				93
				2			A-				90
				3			B+				87
				4			B				83
				5			B-				80
				6			C+				77
				7	 		C				73
				8			C-				70
				9			F				0

Anon7 - 2022
AnonSec Team