1
Data Modeling and Database Design
medium
A healthcare provider's Salesforce org uses a custom object 'Care_Plan__c' with a Lookup to 'Patient__c'. Compliance now requires that a Care Plan cannot exist without a Patient, that the Patient record cannot be deleted while Care Plans reference it, and that each Care Plan should inherit the Patient's sharing settings. The team also needs a roll-up summary of active Care Plans on the Patient record. Which relationship change should the architect recommend?