Question: Ve will extend the model developed in the previous question to also record the usage charges to the arking facilities. he majority of the parking

Ve will extend the model developed in the previous question to also record the usage charges to the arking facilities. he majority of the parking spaces are under cover, and each will be allocated to one member of staff for a nonthly fee. Parking spaces that are not under cover are free to use and each can be allocated for use by ip to 3 members of staff. Fifteen covered parking spaces are reserved for use by visitors to the rganization. However, only members of staff are able to book a pace for the day of the visit. There is no harge for this type of booking, but the member of staff must provide the visitor's vehicle license number Jsing the concept of specialization, modify the model you have created in the previous question to satisfy he new requirements. Provide the assumptions if any to support your design. revious 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 organization's 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 Parking Lot Lot Number(PK) PLot Name PLot Capacity PLot NumfFloor PLot EntranceLocation Staff ID(PK) Staff Name Staff_TeleExtNum Staff VehicleLicense Assigned_Staff Parking Space Space_Num(PK) Assigned Staff(FK) Lot Number(FK) Ve will extend the model developed in the previous question to also record the usage charges to the arking facilities. he majority of the parking spaces are under cover, and each will be allocated to one member of staff for a nonthly fee. Parking spaces that are not under cover are free to use and each can be allocated for use by ip to 3 members of staff. Fifteen covered parking spaces are reserved for use by visitors to the rganization. However, only members of staff are able to book a pace for the day of the visit. There is no harge for this type of booking, but the member of staff must provide the visitor's vehicle license number Jsing the concept of specialization, modify the model you have created in the previous question to satisfy he new requirements. Provide the assumptions if any to support your design. revious 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 organization's 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 Parking Lot Lot Number(PK) PLot Name PLot Capacity PLot NumfFloor PLot EntranceLocation Staff ID(PK) Staff Name Staff_TeleExtNum Staff VehicleLicense Assigned_Staff Parking Space Space_Num(PK) Assigned Staff(FK) Lot Number(FK)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
