We will extend the model developed in the previous question to also record the usage charges to the parking facilities.

The majority of the parking spaces are under cover, and each will be allocated to one member of staff for a monthly fee. Parking spaces that are not under cover are free to use and each can be allocated for use by up to 3 members of staff. Fifteen covered parking spaces are reserved for use by visitors to the organization. However, only members of staff are able to book a pace 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.

Using the concept of specialization, modify the model you have created in the previous question to satisfy the new requirements. Provide the assumptions if any to support your design.

Previous question:

A large organization has several parking lots, which are used by its staff. Each parking lot has a unique name, capacity, number of floors (where appropriate), and entrance location (some large lots have more than one entrance). Each parking lot has parking spaces, which are uniquely identified using a space number. Members of staff can request up to three parking spaces in different parking lots, and each parking space can be assigned to at most 3 members. Each member of staff has a unique number, name, telephone extension number, and vehicle license number. Create a single ER diagram to model the data of the organizations parking facilities. Consider the best practice to handle multi-valued attributes and M:N relationships. Provide the assumptions if any to support your design.

My ER Diagram from previous question (don't know if it's 100% right):

Staff as Parking Lot Lot Number(PK) PLot Name PLot_Capacity PLot NumOfFloor PLot_EntranceLocation Staff_ID(PK) Staff_Name Staff_TeleExtNum Staff VehicleLicense Assigned_Staff Parking Space uses Space_Num(PK) Assigned_Staff(FK) Lot Number(FK)