Introduce specialization/generalization concepts into the ER model shown in Figure 13.11 and described in Exercise 12.13 to show the following:

(a) The majority of parking spaces are under cover and each can be allocated for use by a

member of staff for a monthly rate.

(b) Parking spaces that are not under cover are free to use and each can be allocated for use

by a member of staff.

(c) Up to twenty covered parking spaces are available for use by visitors to the company.

However, only members of staff are able to book out a space for the day of the visit. There is no charge for this type of booking, but the member of staff must provide the visitor’s vehicle

license number.

The final answer to this question is shown as Figure 17.11.

This figure takes the original Figure 13.11 and adds the additional requirements described

above (a) to (c) using enhanced EER concepts.