Design a Data Vault hub-link-satellite pattern

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 a Data Vault hub-link-satellite pattern. Create a hub_customer (business keys), a sat_customer (descriptive attributes with load dates), and a link_customer_order connecting customers to orders.

Practice This Problem

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