Question 3

Question 3

The entity type DISTRIBUTOR has four subclasses:NORTHERN, SOUTHERN, CENTRAL and EASTERN. Draw a separate EER diagram segment for each of the following situations:

a) At a given time, a DISTRIBUTOR must be exactly one of these subclasses.

b) A DISTRIBUTOR may not be one of these subclasses. However, a DISTRIBUTOR who is one of these subclasses cannot at the same time be one of the other subclasses.

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