ER Diagram meets the Notes: For the first three questions (1-3), you will create an ER diagram that requirements. You must specify keys by underlining them. You must also specify the cardin ty and participation constraints in the relationships. Note: There can be several correct answers for the first three questions. Document any unspecified requirements and your assumptions used to make the specification complete. We will grade these based on consistency between your explanation and actual design. If you do not note any assumptions and it differs from our solution, you will lose points. 1. 2018 Winter Olympics Database (20 points): The International Olympic Committee just realized their database doesn't work and need you to design one to meet the following requirements: (a) Each athlete has a name, a country they represent, and the age (e.g., Lindsey Vonn will represent USA and is 34 years old). (b) Each event needs to be recorded (e.g., bobsleigh, curling, figure skating, ice hockey, snowboarding, etc.), with a date, time, and a venue. (c) Athletes participate in at least one event (d) Medals are awarded for each event to the first, second and third place finisher (e.g. Lindsey Vonn wins Gold in Alpine Skiing). 2. Apartment Tracking Database (30 points): You were just hired to develop a database for an apartment management company (e.g., Gables Residential, Marquis, etc.). They would like to the database to meet the following requirements: (a) The company may have several residential communities. (b) Each community has at least one apartment building, which has a unique building id, the name, the address, and the date built. (c) Inside each building are apartment units. (d) Each apartment unit has a unit number, the number of rooms, the number of bedrooms, the sguare footage, and the name of the floor plan. (e) Temants live inside the apartment units. (f) Rental information for the tenant should contain the start date, the end date, and the rent itself. (g) Tenant information includes the name, email and phone number. (h) A tenant can be friends with other tenants. 3. Emory Hospital Database (30 points) You have been asked to design a database for a new hospital at Emory. This hospital needs to store the following information in its database