Design an orders table where each order has a nested ARRAY of line items instead of a separate order

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

Design an orders table where each order has a nested ARRAY of line items instead of a separate order_items table. Each order has a list of products with quantity and price stored inline.

Practice This Problem

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