What is Master Detail relationship and look up relationship in Salesforce

What is Master Detail relationship and look up relationship in Salesforce

Master Detail relationship is the Parent child relationship. In which Master represents Parent and detail represents Child. If Parent is deleted then Child also gets deleted. Rollup summary fields can only be created on Master records which will calculate the SUM, AVG, MIN of the Child records.

Look up relationship is something like “has-a” (Containership) relationship. Where one record has reference to other records. When one record is deleted then there is no impact on other records.

Master Detail relationship :

-          Child record must have parent record

-          Cascade record level security

-          Cascade record deletion

-          Roll up summary fields on parent

-          Standard obj cant be detail object

look up relationship:

-          relationship is optional(no parent requirement)

-          no impact on security

-          roll up summary field cant be established