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

i need only 1.2 please 1.2 only i need only 1.2 please 1.2 only Q1. ER Model We want

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!