(Solved): 1. (2 pts) Read the following scenario. Then create an ER diagram using Crow's Foot notation that ...

1. (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. Place you ER diagram image below: 2. (2 pts) Draw the ERD for the following scenario. Include all the attributes being sure to identify the primary key. Note that one of your tables will have a composite identifier. You want to maintain a list of your contacts. You retain the following information, lastname, firstname, address, city, state, zip code and phone numbers. [Hint: note that the contacts can have multiple phone numbers - this is the classic multivalued attribute problem AND ONE YOU SHOULD LEARN!] Place you ER diagram image below: