Top 50 schema design Interview Questions

Design a real-time Uber interaction schema and summarize each user's interaction activity, including users with no recorded events.

schema designdata managementdatabase designUber

Model clinical trial entities and report monthly enrollment, visit completion, prior-month enrollment, and center rankings.

data relationshipsschema designnormalizationMSD

Model consumer requirements relationally and report each consumer's active requirement count and latest assignment.

data relationshipsJoinsschema designAffirm

Track each vehicle part from production events through delivery using CTEs, joins, conditional aggregation, and LAG.

data relationshipsfact tablesschema designTesla

Build a validated account-level analytical model from source account and event data using aggregation and a left join.

schema designdatabase designdata validationWaymo

Design a normalized simulation schema and retrieve each team's latest completed dataset run.

data relationshipsJoinsschema designWaymo