Answered You can hire a professional tutor to get the answer.


You have been asked to design a database for Professional Baseball. Your diagram must contain all the tables needed to meet the business rules below....

You have been asked to design a database for Professional Baseball. Your diagram must contain all the tables needed to meet the business rules below. For each table, you must show the primary keys and relationships to other tables. 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....

2. The people recorded in rule #1 can be in one or more of the following types:

a. Pitcher

b. Fielder

c. Manager

Different information without overlap is stored for each of the types.

3. 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, team and league over their entire professional career.

4. Each of these people can be in one or more types in a given year and can be a member of one or more teams in a given year 5. Each Team belongs to a League

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

7. The database needs to track if a person went to college and, if they did, the years they attended. The details of each college or university needs to be available (college name, address, etc...). Remember people can go to one or more colleges and can attend more than 1 college in a given academic year.

8. The database needs to track how much everyone is paid every year. Professional Baseball also produces salary information by team and league.

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

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

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

12. The people who are not managers must belong to one of 3 unions. The database must track which union the person belongs to for the current year. Each year, the members of each union elect a president for their union. The database must track the current and past presidents of each of the unions.

Your submission should use either Crow's Foot notation or the modified Crow's Foot utilized in the text. The submission should show the required tables, keys (you can define the attributes) and the relationships between the tables. You can use any tool you prefer, including drawing by hand, to submit the assignment. If you draw the ERD, please submit a picture of it in Moodle

Show more
Ask a Question