Answered step by step
Verified Expert Solution
Question
1 Approved Answer
It has to be done in MySqlWorkbench Part-ll Create an E-R Diagram for the following problem as seen in lecture. You MUST use a design
It has to be done in MySqlWorkbench
Part-ll Create an E-R Diagram for the following problem as seen in lecture. You MUST use a design tool to create the diagrams. Handwritten diagrams will not be accepted. You must show primary keys and foreign keys on the entities. Create an E-R Diagram to meet the following requirements: (a) A large organization has several parking lots, which are used by staff. (b) Each parking lot has a unique name, location, capacity, and number of floors (where appropriate). (c) Each parking lot has parking spaces, which are uniquely identified using a space number (d) 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. (e) The majority of parking spaces are under cover and each can be allocated for use by a member of staff for a monthly rate (f) Parking spaces that are not under cover are free to use when available (g) 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 Provide any assumptions necessary to support your mode
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started