Question 2 (20 pts) Dream Park has several locations throughout the city of Atlanta. You are one of members from DBA staff of Advanced Software Company and your current project assignment is to work with Dream Park management to create a conceptual design for their database. Following are the requirements. o Each location is recorded with a location id, address and a maximum capacity. o Each location has different areas (Ex: picnic, party, etc). Each area has an area id, a description and a size. o Each location is managed by one of its areas. o Only for each picnic area, there are multiple sites. o Each site is identified by the size number which is unique within each picnic area. o Events are held at the areas and Dream Park tracks event id, event name, description as well as the area where the event is being held. o One event can be held across multiple areas. o There are three different types of events namely sporting events, performances and conferences. Sporting events have the name of the team. Conferences have a sponsoring organization. o Dream Park also wishes to track information about visitors who visit different locations. They assign each visitor an id, store their name, date of birth, and registration date. o They also record information about the location visited by each visitor and the date of each visit. Dream Park rents out Bikes, Boats and Sport items for the visitors. Bikes have a bike id and boats have number of seats, boat id, color and sports items have item id and item type. o Above all equipments are not rental equipments. Some of them are to be used by the employees of Dream Park. Rentals are rented by visitors. Each time the equipment is rented, Park records the date and time for the rent. Draw an EER diagram for the conceptual design for the above scenario. Indicate all key and cardinality constraints, specialization or generalizations, and any assumptions that you make