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. Each location has different areas (Ex: picnic, party, etc). Each area has an area id, a description and a size. Each location is managed by one of its areas. o Only for each picnic area, there are multiple sites. 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. One event can be held across multiple areas. 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. They also record information about the location visited by each visitor and the date of each visit. o 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. 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. The organizers of National Football League (NFL) have decided to store information about their teams, players and games (as well as other information) in a database. You have been assigned to design and develop a database to serve that purpose. As the first step, you need to listen to their requirements and create a conceptual design. Following are their requirements: o NFL has number of teams. Each team has a unique name and their city, coach's name are also recorded. o Each player is a member of only one team. Such player has a name(first name, last name), a position which he plays at (ex: center, guard, tackle), expert class (a value in scale 1-5) and uniquely identified by player id assigned by NFL. o Each player has a set of injury records where each record associates with a record id (a unique number across the records of single player) and a description of the injury. o Each team has a captain who is also a player. o One game is played between two teams (called as host team and guest team) and also the date and the result for each game are recorded. Construct an ER diagram for NFL. Indicate all key and cardinality constraints and any assumptions that you make
