Question: drow ER Diagram for soccer example : A database is being constructed to keep track of the teams and games of a sports league. A
drow ER Diagram for soccer example :

A database is being constructed to keep track of the teams and games of a sports league. A team has a number of players, not all of whom participate in each game It is desired to keep track of the players participating in each game for each team, the positions they played in that game, and the result of the game. Design an ER schema diagram for this application, stating any assumptions you make. Choose your favorite sport (e.g., football, soccer, basketball, baseball, cricket etc.). Specify the (min, max) constraint on each participation of an entity type in a relationship type. Use a design tool (ERDPlus, TerraER, MS Visio, and Smartdraw etc.) to create the design. No hand-drawn submissions will be accepted
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
