Question: At a weekend retreat, the entity type PERSON has three subtypes: CAMPER, BIKER, and RUNNER. Draw a separate EER diagram segment for each of the

At a weekend retreat, the entity type PERSON has three subtypes: CAMPER, BIKER, and RUNNER. Draw a separate EER diagram segment for each of the following situations:

a. At a given time, a person must be exactly one of these subtypes.

b. A person may or may not be one of these subtypes.
However, a person who is one of these subtypes cannot at the same time be one of the other subtypes.

c. A person may or may not be one of these subtypes. On the other hand, a person may be any two (or even three)
of these subtypes at the same time.

d. At a given time, a person must be at least one of these subtypes.

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 Database Management Systems Questions!