A supplier_parts table has a composite key (supplier_id, part_id) plus columns supplier_name and qua

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 supplier_parts table has a composite key (supplier_id, part_id) plus columns supplier_name and quantity. The supplier_name depends only on supplier_id, not the full composite key. This is a partial dependency. Extract suppliers into a separate table to achieve 2NF.

Practice This Problem

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