Describe how Married_to can be modeled as a recursive relationship?

QUESTION:

“Describe how Married_to can be modeled as a recursive relationship”?

SOLUTION

Married_to can be modeled as a recursive relationship type if you think of it in terms of a PERSON entity type (e.g., Person 1 can be married to at most one other person, Person 2 can be married to at most one other person – either Person 1 or Person 3 or Person n, etc.). The following is an example of what an ER diagram and accompanying instance diagram might look like.