Design a database for Professional Baseball. '1'our diagram must contain all the tables needed to meet the

Fantastic news! We've Found the answer you've been seeking!

Question:

Design a database for Professional Baseball. '1'our diagram must contain all the tables needed to meet the business rules below. For ea ch table, you must show the primary keys, the relationships to other tables, cardinality and if there is total or partial participation between the entities. '1'our diagram should also include any attributes included in the business rules properly diagramed. All the information you need will be in slides 1 thru 29 of the Chapter? presentation. The database is to contain the following:

1.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.

2.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.

3.Each player plays for a team and may play for more than 1 team in a given year.

4.Each Team belongs to a League

5.Each Team has their own Stadium or Ball Park they play in. Elder time, teams more to new stadiums. The database needs to keep track of when a team played in which stadium

6.The database needs to track how much everyone is paid eyry yea r. Professional Baseball also produces salary information by team and league.

7.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.

8.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 T' there is a yote to determine who out of the nominated will be add for the year. The database must track who is nominated each year and also store the year they are elected.

9.The database should keep repetitive information to a minimum. Use lechered possible rather than storing the full information. IDs be part of the table that contains the full information for reporting. 1four submission should use either Crow's Foot notation or the modified Crow's Foot utilized in the test.