The data requirements are summarized as follows:
View the step-by-step solution to:

Question

Can you please help me consider a database system for a baseball organization such as the major leagues. The data

requirements are summarized as follows: • The personnel involved in the league include players, coaches, managers, and umpires. Each is identified by a unique personnel id. They are also described by their first and last names along with the date and place of birth. • Players are further described by other attributes such as their batting orientation (left, right, or switch) and have a lifetime batting average (BA). • Within the players group is a subset of players called pitchers. Pitchers have a lifetime ERA (earned run average) associated with them. • Teams are uniquely identified by their names. Teams are also described by the city in which they are located and the division and league in which they play (such as Central division of the American League). • Teams have one manager, a number of coaches, and a number of players. • Games are played between two teams with one designated as the home team and the other the visiting team on a particular date. The score (runs, hits, and errors) are recorded for each team. The team with the most runs is declared the winner of the game. • With each finished game, a winning pitcher and a losing pitcher are recorded. In case there is a save awarded, the save pitcher is also recorded. • With each finished game, the number of hits (singles, doubles, triples, and home runs) obtained by each player is also recorded. Design an Enhanced Entity-Relationship diagram for the BASEBALL database. 

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes