Question

A SCHEDULE table contains data about course schedules in a given term in a university. The table includes 6 attributes: CourseID, SectionID, CourseTitle, ScheduledDayTime, DeptName (offering the course), and DeptLocation. The primary key of this table includes CourseID and SectionID. The functional dependencies are:

CourseID → CourseTitle (e.g., MIST.3030 → “Database Management Systems”)

CourseID → DeptName (e.g., MIST.3030 → “Operations & Information Systems”)

DeptName → DeptLocation (e.g., “Operations & Information Systems” → PTB Building)

CourseID, SectionID → ScheduledDayTime (e.g., MIST.3030 Sec 201 → T/Th 3:30-4:45pm)

Decompose this non-3NF table into 3NF relations in graphic format. Show all functional dependencies and links on the decomposed relations.

Answer 1