IS-3030 Database Design Homework Assignment \#1: Conceptual Data Modeling Based on the following narrative description, conduct the conceptual data modeling and draw an Entity-Relationship diagram according to the requirements. You should specify the identifier and other non-key attributes for each entity type. For relationship types, you should specify: (1) the (min, max) cardinality ratios (you can use any representation notation), and (2) the relationship attributes if it is appropriate to include them. Paris 2024 Summer Olympics You have been asked by the International Olympic Committee (IOC) to design a database for the 2024 Summer Olympics in Paris, France. IOC wants to keep track of information for each participating country such as name, population, team color, continent, nation-anthem, the contact person and the number of participants. Each participating country consists of athletes, referees and delegates. IOC wants to keep track of information for all delegates such as passport\#, name, gender, title, and birthday. For each athlete, IOC wants to keep track of the A\#, passport\#, name, birthday, gender, height, years of participation and weight. For each referee, IOC wants to keep track of the passport\#, referee\#, name, birthday, gender, years-of-participation, and areas-of-expertise. Several games happen during the Summer Olympics. An example of a game is the men's 400 meter. A game has several heats. IOC needs to keep track of the details of each heat. Heat details include heat\#, game name, and the number of athletes who participate in each heat. An athlete can participate in many heats but must participate in at least one. You must record the results of each athlete in each heat. The details for each athlete in each heat include the athlete's time and rank. In addition, you must record the winners (Gold, Silver, and Bronze) of each game. Referees are assigned to heats. Each heat should have at least one referee and a referee can be assigned to more than heat. Heats are held in different facilities (e.g., Track \& Field Arena) on different dates. The detailed information of each facility such as name, location, capacity, ower and available transportation services must be recorded for reference. Note: The specifications given above are quite comprehensive, but of course not complete. If you need clarification or additional information, please feel free to ask the instructor. Another option is to make reasonable assumptions and state them to support your conceptual data modeling. None of the assumptions you make can nullify or contradict the business rules stated above