Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Web Database Development Step By Step

Authors: Jim Buyens

1st Edition

0735609667, 978-0735609662

More Books

Students also viewed these Databases questions

Question

3. Describe the strategic training and development process.

Answered: 1 week ago

Question

10. Microsoft Corporation

Answered: 1 week ago