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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started