Question: I need chapter 5 question 1 2. A large organization has several parking lots, which are used by its staff. Each parking lot has a
I need chapter 5 question 1

2. 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. Chapter 5 1. 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 visitor's 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 esign
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
