Both instructor name and instructor location are dependent on instructor number. Therefore, instructor name and Instructor location are dependent on the primary key of the student course (enrolment table) but via the non-key attribute of instructor number. Therefore, the transitive dependency needs to be removed before the third normal form is achieved.

Required

(b) 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, Instructor location