50%(2)1 out of 2 people found this document helpful
This preview shows page 1 out of 1 page.
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.Pitcherb.Fielderc.ManagerDifferent 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 ormore teams in a given year5.Each Team belongs to a League6.Each Team has their own Stadium or Ball Park they play in. Over time, teams move to new