Problem : Enhanced Entity-Relationship Diagram
Create an HER model for each of the following descriptions:
A large organization has several parking lots, which are use by staff. Each parking lot has a unique name, location, capacity, and number of floors (where appropriate).
Each parking lot has parking spaces, which are uniquely identified using number.
Members of staff can request the use of a parking space. Each member of staff has a unique number, name, telephone extension number, and vehicle license number.
The majority of parking spaces are covered and each can be allocated for use by a member of staff for a monthly rate.
Parking spaces that are uncovered is metered (25 cents/15 min) so keeping track of time remaining on meter is important to the company's parking personnel. 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.