FIT 100
Relational DB’s Use Keys To Show Relationships
vSID Name Instr.ID Name
v 1 Mary Hi 1 Mel
v 2 Peter Yi 2 Russ
v 3 Paul Go
v 4 Nancy Yo
v Course ID Name Room
v
1 FIT 100 EE1
v
2 IS 320 B309
v
3 IS 480 B209
SID CourseID Instr
ID
3 1 1
1 1 1
2 3 1
4 2 2
3 2 2
2 1 1
Note:
No Data Redundancies