Instructor name is dependent on the primary key of the student course

(enrolment table) via the non-key attribute of instructor number. Instructor location is dependent on part of the primary key (the course number attribute) and instructor number (a non-key attribute). Therefore, we need to remove these transitive dependencies to achieve third normal form.

Required

(c) Explain the logic underlying the table; that is, how the university works given the above change. Comment on the E-R diagram.

Transcribed Image Text:

Third normal form Student table: Student number Course table: Course number, Course title Student course (enrolment table). Student number, Course number, Instructor number, Grade Instructor table: Instructor number, Instructor name Course room allocation table Course number, Instructor number, Instructor location