Question: Introduce specialization/generalization concepts into the ER model shown in Figure 13.11 (a) The majority of parking spaces are under cover and each can be allocated

Introduce specialization/generalization concepts into the ER model shown in Figure 13.11  Introduce specialization/generalization concepts into the ER model shown in Figure 13.11
(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 visitors vehicle license number.

Staff Uses Provides ParkingLot staffNo (PK) 0 name 01 spaceNo (PK)1 1 parkinglotName (PK location capacity extension TelNo Figure 13.11

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!