A relational table stores information about university students with the following attributes:

`StudentID, CourseCode, Instructor, Room, Time`

Functional dependencies are:

1. $StudentID \rightarrow CourseCode$
2. $CourseCode \rightarrow Instructor, Room, Time$
3. $Instructor \rightarrow Room$

Determine the highest normal form the table satisfies. If it is not in Third Normal Form, provide a lossless‑decomposition into tables that are in 3NF.

Question

A relational table stores information about university students with the following attributes:

`StudentID, CourseCode, Instructor, Room, Time`

Functional dependencies are:

1. $StudentID \rightarrow CourseCode$
2. $CourseCode \rightarrow Instructor, Room, Time$
3. $Instructor \rightarrow Room$

Determine the highest normal form the table satisfies. If it is not in Third Normal Form, provide a lossless‑decomposition into tables that are in 3NF.

Accepted Answer

The table is in 2NF only. A 3NF decomposition is:
StudentCourse(StudentID, CourseCode)
CourseInstructorTime(CourseCode, Instructor, Time)
InstructorRoom(Instructor, Room)

Gce Model Questions Vol1 2024 Computer Studies Question 25

Answer Options

About This Question

Master the Exam!