ENHANCE ENTITY RELATIOSHIP DIAGRAM The entity type PERSON has the following attributes: SSN, name, address (City/State/Zip), date of birth, age, and contact number. The entity also has the three subtypes: CAMPER, BIKER, AND RUNNER. Draw a separate diagram segment for each of the following situations: 1. At a given time, a person must be exactly one of three subtypes. 2. 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. 3. A person may or may not be the one of these subtypes. On the other hand, a person may be any two (or even three) of these subtypes at the same time. 4. At a given time, a person must be at least one of these subtypes.
ENHANCE ENTITY RELATIOSHIP DIAGRAM
The entity type PERSON has the following attributes: SSN, name, address (City/State/Zip), date of birth, age, and contact number. The entity also has the three subtypes: CAMPER, BIKER, AND RUNNER. Draw a separate diagram segment for each of the following situations:
1. At a given time, a person must be exactly one of three subtypes.
2. 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.
3. A person may or may not be the one of these subtypes. On the other hand, a person may be any two (or even three) of these subtypes at the same time.
4. At a given time, a person must be at least one of these subtypes.
Step by step
Solved in 2 steps with 3 images