Remove the transitive dependency, instructor number becomes a foreign key in the course number table (shown by a dashed line underneath the instructor number in the course table). Then instructor number becomes a primary key in its own table. The attributes instructor name and instructor location are now attributes of the instructor table.

Required

(a) The table has been normalised to third normal form. Explain the logic underlying the table; that is, how the university works. Comment on the entity-relationship diagram.

Transcribed Image Text:

E-R diagram Student number Student number, Course number, Grade Course number. Course title. Instructor number Instructor number, Instructor name, Instructor location