Question: Given the ERD below, what will be the constraints on the foreign key column? The ERD models the following: A customer can refer many other

Given the ERD below, what will be the constraints on the foreign key column? The ERD models the following:
A customer can refer many other customers but may refer no other customers.
A customer may have been referred by at most one other customer but may not have been referred by any other customer.
Customer refers customer one to many unary ERD. Customer entity followed by one, zero, relationship line, zero, crows foot, and back to customer entity.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!