A student_courses table stores multiple course names as a comma-separated list in one column

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 student_courses table stores multiple course names as a comma-separated list in one column. This violates 1NF. Redesign it so each enrollment is its own row, with atomic values in every column.

Practice This Problem

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