Database

At a weekend retreat, the entity type PERSON has three subtypes: CAMPER, BIKER and RUNNER. Draw the 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 an (pr even three) of these subtypes at the same time. d) At a given time, a person must be at least on of these subtypes