0%(3)0 out of 3 people found this document helpful
This preview shows page 1 out of 1 page.
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 League5.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 stadium6.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 7ththere 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. 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), attributes as indicated, cardinality, participation 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. I recommend that you draw the diagram by hand. It will be faster and not requireyou to learn how to use any software.