Question: 2. (a) Draw an ER diagram for a database that stores tennis players. - For each player, we store his name, date of birth, country

2. (a) Draw an ER diagram for a database that stores tennis players. - For each player, we store his name, date of birth, country and ranking. - Each player plays matches with one or more other players. - However, each player plays only one match with one particular opponent. - For each match played between two players, we store the name of stadium and the score. - For each player, we also store his ideal player. Each player has at most one ideal player. (b) Convert the above ER--?diagram into a relational model.

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!