Question: Draw a data model in SQL Workbench for the scenario below. We want to keep track of basic facts about gymnastics tournaments. There are tournaments

Draw a data model in SQL Workbench for the scenario below. We want to keep track of basic facts about gymnastics tournaments. There are tournaments a few times a year, and each tournament involves many teams. For example, the latest tournament was in Chicago, on February 3; it involved 15 teams. There will be another tournament in Denver, next January, involving many (but not all) of the same teams. A gymnastic team includes many gymnasts. Although this is rare, it is possible for a particular gymnast to change teams over time, or even leave a team and join it later. Each team has a unique id. It also has a name. Basic information about each gymnast is stored. We are particularly interested in knowing, for each tournament, which particular team and which particular gymnast won the tournament (note that winning gymnast may not be from the winning team)

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 Programming Questions!