Question: ( 2 pts ) Read the following scenario. Then create an ER diagram using Crow's Foot notation that identifies entities, attributes { be sure to

(2 pts) Read the following scenario. Then create an ER diagram using Crow's Foot notation that identifies entities, attributes {be sure to denote the identifier } and relationships including optionality and cardinality.
A large organization has several parking lots, which are used by staff. Each parking lot has a unique name, location, capacity, and number of floors (where appropriate). Each parking lot has parking spaces, which are uniquely identified using a space number. Each staff member has a unique staff number, name, telephone number, and vehicle license number.
A staff member can request the sole use of a single parking space in anyone of the parking lots.
 (2 pts) Read the following scenario. Then create an ER diagram

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!