Question

The majority of parking spaces are uncover or covered and cach covered spaces can be allocated for use by a member of staff for a monthly rate. Parking spaces that are uncovered are free to use and each can be allocated for use by a member of staff. 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. Draw EER diagram showing all the entities, sub entities and cardinalities.

Answer 1

An EER diagram for the parking space system would include entities like ParkingSpace, CoveredParkingSpace, UncoveredParkingSpace, Staff, and Visitor. It would detail relationships and cardinalities such as a one-to-many relationship between Staff and ParkingSpace, and a capped one-to-many relationship between Visitor and CoveredParkingSpace, with a limit of twenty spaces for visitors.

Step-by-step explanation:

To draw an Enhanced Entity-Relationship (EER) diagram for the described parking space system, we first need to identify the entities, relationships, and cardinalities.

• ParkingSpace - An entity that represents all parking spaces.
• CoveredParkingSpace - A subtype of ParkingSpace, representing only the covered parking spaces.
• UncoveredParkingSpace - A subtype of ParkingSpace, representing uncovered parking spaces.
• Staff - Represents staff members who can book spaces.
• Visitor - Represents visitors who can use the parking space.

Next, we will define the relationships:

• A Staff 'books' a ParkingSpace. A staff member can book multiple parking spaces, but a parking space can be booked by only one staff member at a time (one-to-many relationship).
• A Visitor 'uses' a CoveredParkingSpace. A visitor can use only one parking space at a time, and up to twenty covered parking spaces can be used by visitors (one-to-many relationship).

The cardinalities for these relationships would be depicted in the EER diagram, showing '1:N' for the staff to parking spaces and '1:20' (max) for visitors to covered parking spaces.