Question: i need only 1.2 please 1.2 only Q1. ER Model We want to design a database for storing the information of U.S. athletes and their
Q1. ER Model We want to design a database for storing the information of U.S. athletes and their participations in Olympic games. - An athlete has his/her SSN, the name, and the birth date. - Each Olympiad has the year, the country, and the city. For example, the 2008 Olympic game was held in Beijing, China. - An athlete can participate in several sports in an Olympiad. For example, Michael Armstrong participated in the swimming, diving, and water polo events. - Every athlete in our database participated in at least one Olympiad. Every Olympiad has at least one athlete (and actually, several thousands). 1.1. Draw an ER diagram for this database. Make sure to indicate primary keys, cardinality constraints, weak entities (if any), and participation constraints. 1.2. Turn the ER diagram into tables: give SQL statements to create the tables. Make sure to indicate primary keys, foreign keys, if any. Specify the appropriate integrity constraints to enforce the total/partial coverage, and overlap constraints, if any
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
