Will thumbs up, previous answer on this site is incorrect

Question 2 (50 pts)

A local organization has several parking lots, which are used by staff. One of your high school friends, Taylor, was assigned to create the conceptual schema for the organizations parking lots. But apparently, Taylor did not think conceptual schema design was important, missed the classes, and now needs your help. Below are the requirements provided by the organization:

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 a space number. Members of staff can request the sole use of a single parking space. Each member of staff has a unique number, name, telephone extension number, and vehicle license number.

The majority of parking spaces are under cover and each can be allocated for use by a member of staff for a monthly rate.

Parking spaces that are not under cover 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.

1. Help your friend by designing a conceptual schema for the parking lots and draw an EER diagram for your schema. Indicate all key and cardinality constraints, specialization or generalizations, and any assumptions that you make.
2. Create a relational schema by mapping the EER diagram you created in (a).