Relational DB’s Use Keys To Show Relationships

SID Name Instr.ID Name

1 Mary Hi 1 Mel

2 Peter Yi 2 Russ

3 Paul Go

4 Nancy Yo

Course ID Name Room

1 FIT 100 EE1

2 IS 320 B309

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

Previous slide

Next slide

Back to first slide

View graphic version