You're working on a CRM data pipeline and need to model relationships between records before loading and transforming data.
What is the difference between master-detail and lookup relationships, and when would you use each?
