Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider a database system for a baseball organization such as the major leagues. The data requirements are summanzed as follows: I The personnel involved in

image text in transcribed

Consider a database system for a baseball organization such as the major leagues. The data requirements are summanzed as follows: I 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. I 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. I 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). I Teams have one manager, a number of coaches, and a number of players. 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. WWith each finished game, a winning pitcher and a losing pitcher are recorded. In case there is a save avarded, the save pitcher is also recorded. WWith each finished game, the number of hits (singles, doubles, triples, and home runs) obtained by each player is also recorded. Design an ER/EER diagram for the BASEBALL database and state any assumptions you make

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Analysis In Microsoft Excel

Authors: Alex Holloway

1st Edition

B0CCCPKTTX, 979-8852388452

More Books

Students also viewed these Databases questions