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/MichaelMalz/CST1600/Resources/Notes/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/MichaelMalz/CST1600/Resources/Notes/2021-03-23.txt
* Primary key
@ Foreign key
^ Unique field

UNF
Student_Grade_Report (StudentNo, StudentName, Major, CourseNo, CourseName, InstructorNo, InstructorName, InstructorLocation, Grade)
											1					 Jim					CST		 CST1600   Database		 1             Jim             Home                A
											1					 Jim					CST		 CST1021   HTML & CSS	 1             Jim             Home                A
											1					 Jim					CST		 CST1794   Programming 2             Allen           Home                A
											2					 Austin				CST		 CST1600   Database		 1             Jim             Home                A
1NF
Student (StudentNo*, StudentName, Major)
StudentCourse (StudentNo*, CourseNo*, CourseName, InstructorNo, InstructorName, InstructorLocation, Grade)
2NF
Student (StudentNo*, StudentName, Major)
CourseGrade (StudentNo*@, CourseNo*@, Grade)
CourseInstructor (CourseNo*, CourseName, InstructorNo, InstructorName, InstructorLocation)
3NF
Student (StudentNo*, StudentName, Major)
CourseGrade (StudentNo*@, CourseNo*@, Grade)
Course (CourseNo*, CourseName, InstructorNo@)
Instructor (InstructorNo*, InstructorName, InstructorLocation)

Jim's 3NF
Student ( StudentNo*, StudentName, Major@ )
				 1					 Jim					CST
				 2					 Austin				CP

Major ( Code* )
				CST
				CP

Course ( CourseId*, CourseNo, CourseName )
				 1					CST1600    Database	
				 2					CST1021    HTML & CSS
				 3					CST1794    Programming

Instructor ( InstructorNo*, InstructorName, InstructorLocation )
						 1             Jim 							Home
						 2             Allen						Home

Class ( ClassId^, CourseId*, InstructorNo* )
				1					1					1
				2					2					1
				3					3					2

StudentClassGrade (StudentNo*, ClassId*, Grade)
										1						1					 A
										1						2					 A
										1						3					 A
										2						1					 A

Exmple 1
emp ( emp_id*, emp_name, emp_address, emp_dept )

emp ( emp_id*, emp_name, emp_address, dept_id@ )
dept ( dept_id* )
or
emp ( emp_id*, emp_name, emp_address )
emp_dept ( emp_id*@, dept_id*@ )
dept ( dept_id* )

Example 2
emp ( emp_id*	emp_name	emp_address, emp_mobile* )

emp ( emp_id*, emp_name, emp_address )
emp_phone ( emp_id*@, emp_mobile* )

Anon7 - 2022
AnonSec Team