A course_assignments table has (professor, course, room) where a professor can teach in multiple roo

A medium Data Modeling interview practice problem on DataDriven. Write and execute real data modeling code with instant grading.

Domain

Data Modeling

Difficulty

medium

Problem

A course_assignments table has (professor, course, room) where a professor can teach in multiple rooms and multiple courses. A room determines the building. Extract building into a separate table to achieve BCNF.

Practice This Problem

Solve this Data Modeling problem with real code execution. DataDriven runs your solution and grades it automatically.