Question: You have been asked to design a database ERD for Professional Baseball. Your ERD diagram must contain all the tables needed to meet the business
You have been asked to design a database ERD for Professional Baseball. Your ERD diagram must contain all the tables needed to meet the business rules below. For each table, you must show the primary keys, the relationships to other tables, cardinality and if there is total or partial participation between the entities. Your diagram should also include any attributes included in the business rules properly diagramed. The database is to contain the following:
- A record for each person who was either a player or a manager for any of the teams that contains the basic information about the person such as name, address, etc. There needs to be key created to link all the information regarding a particular player and the year the information pertains to.
- Batting information is also stored for each person. Professional Baseball reports on batting information by person, team and league. Person information is reported by year and should also be also to be reported on by team and league over their entire professional career.
- Each player plays for a team and may play for more than 1 team in a given year.
- Each Team belongs to a League
- Each Team has their own Stadium or Ball Park they play in. Over time, teams move to new stadiums. The database needs to keep track of when a team played in which stadium
- The database needs to track how much everyone is paid every year. Professional Baseball also produces salary information by team and league.
- Professional Baseball gives out awards each year. Sometimes the awards are shared between to people. For example, if 2 players had the same batting average and it was the highest in the league for the year, they would both be given the award for best batter.
- Professional Baseball has a Hall of Fame. Each year, sports writers nominate the people to be added to the Hall of Fame and on July 7th there is a vote to determine who out of the nominated will be added for the year. The database must track who is nominated each year and also store the year they are elected.
- The database should keep repetitive information to a minimum. Use IDs where possible rather than storing the full information. IDs be part of the table that contains the full information for reporting.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
