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.

Transcribed Image Text:

Staff Uses Space Provides ParkingLot staffNo (PK 0.1 0.1 spaceNo (PK 1 1..1 parkingLotName (PK) location ame extensionTelNo vehLicenseNo capacity noofFloors