How do you configure a master-detail relationship versus a lookup relationship, and what are the implications on record deletion?