There is a dependency arrow from instructor name to instructor number and from instructor location to instructor number. Therefore, we have a transitive dependency:

instructor name is dependent on the primary key, course number, via the non-key attribute instructor number. The same situation arises with instructor location. To remove the transitive dependencies we need to move to third normal form.

Transcribed Image Text:

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