A books table stores (book_id, title, author_id, author_name, publisher_id, publisher_name)

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 books table stores (book_id, title, author_id, author_name, publisher_id, publisher_name). Author and publisher names depend on their IDs, not book_id. Extract both to achieve 3NF.

Practice This Problem

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