Question: Create a complete Entity-Relationship (ER) diagram for a database that stores the following information about a baseball league. You should model the Entities and their

Create a complete Entity-Relationship (ER) diagram for a database that stores the following information about a baseball league. You should model the Entities and their attributes, as well as the Relationships and their constraints. Write both the minimum and maximum participation of entities in a relationship as explained in class: for example, if a constraint states that a minimum of 2 and a maximum of N entities can participate in the relationship, write 2:N (not just N).

* The database stores information about players, teams, and games. A player has a unique player name. A team has a unique team name. A game has a unique game number. These are the only entities in the database.

* A player plays for one team at any given time. The start date and end date for the players assignment on the team is recorded. A team will consists of 9 or more players.

* The database keeps track of every time a player participates in a game. It also stores the players performance rating (A,B,C,D,F).

* For each game, there will be one home team and one away team. The date, time, and field name will be recorded for each game.

* For each game, the Inning Score for the home team and the away team will be stored. The Inning Score consists of: the number of runs, hits, and errors. The Final Score of the game will be also be stored for both the home team and the away team (runs, hits, and errors)

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!