When designing a data model for a multi-cloud Salesforce org, what are the key considerations for choosing between lookup relationships and master-detail relationships?