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:

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.
2. 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.
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. Over time, teams move 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 every year. 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 7^th 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.
9. 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.

=> solution

Based on above diagram solve the following question below.

You have been asked to add additional information to the database for Professional Baseball you designed in the first assignment. For this part of the assignment, please make sure you include the appropriate bridge tables, specialization hierarchies and time dependent tables. 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. The people recorded in the database can be in one or more of the following types:a.Pitcherb. Fielderc.ManagerDifferent information without overlap is stored for each of the types.

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

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

4. 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 and all prior years. 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 Crows Foot notation or the modified Crows 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.

you can use any tool or u can draw by hand

Show transcribed image textAwards Stadium Information Person_Type Award ID Name Person_ID Salary_Information Salary RecordID Salary Person_ID Stadium ID Name Location Team_Played_On Type ID Type_Info Receives Has Is of Maintains Attends College College ID Name Address Ph_number Team + Team ID Belongs to Name Own_stadium League League ID Name Date Person + Person ID Belongs to Name Address Ph_Number Batting Info Team League Schools_attended Belongs to Year_Of_Schooling Union Has Union_ID Salary President President_Information President ID Name Year Nominated to Hall of fame Nominates ID Name Person_ID Nominated_Year Elected_Year Sports_writer Writer ID Name Address Ph_Number

Awards Stadium Information Person_Type Award ID Name Person_ID Salary_Information Salary RecordID Salary Person_ID Stadium ID Name Location Team_Played_On Type ID Type_Info Receives Has Is of Maintains Attends College College ID Name Address Ph_number Team + Team ID Belongs to Name Own_stadium League League ID Name Date Person + Person ID Belongs to Name Address Ph_Number Batting Info Team League Schools_attended Belongs to Year_Of_Schooling Union Has Union_ID Salary President President_Information President ID Name Year Nominated to Hall of fame Nominates ID Name Person_ID Nominated_Year Elected_Year Sports_writer Writer ID Name Address Ph_Number Awards Stadium Information Person_Type Award ID Name Person_ID Salary_Information Salary RecordID Salary Person_ID Stadium ID Name Location Team_Played_On Type ID Type_Info Receives Has Is of Maintains Attends College College ID Name Address Ph_number Team + Team ID Belongs to Name Own_stadium League League ID Name Date Person + Person ID Belongs to Name Address Ph_Number Batting Info Team League Schools_attended Belongs to Year_Of_Schooling Union Has Union_ID Salary President President_Information President ID Name Year Nominated to Hall of fame Nominates ID Name Person_ID Nominated_Year Elected_Year Sports_writer Writer ID Name Address Ph_Number