An app builder is creating a custom object called Testimonial__c and wants to connect Testimonial__c records with both the submitter’s Contact record and Account record. If the Account is deleted, the Testimonial__c should also be deleted. If the Contact is deleted, but the Account remains, the Testimonial__c should remain.
How should this be accomplished?