Draw an entity-relationship diagram that describes the following business environment. Orlando Junior Baseball wants to maintain information about its teams, their coaches, players, and bats.  The information about players is historic.  For each team, the league wants to keep track of all of the players who have ever played on the team, including the current players.  For each player, it wants to know about the player’s name, age, and every team the player ever played for. Currently and historically, each team has and has had many players.  To be of interest to the league, a player must have played on at least one and possibly many teams during his career. The league wants to keep track of each team’s team number, which is unique, its name, the city in which it is based, and the name of its manager.  Coaches have a name (which is only assumed to be unique within its team) and a telephone number.  Coaches have units of work experience, which are described by the type of experience and the number of years of that type of experience.  A coach works for only one team.  A team has at least one and usually several coaches. Bats are described by their serial numbers (which are only unique within a team) and their manufacturer’s name.  Each team owns at least one and generally many bats.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Draw an entity-relationship diagram that describes the following business environment.

Orlando Junior Baseball wants to maintain information about its teams, their coaches, players, and bats. 

The information about players is historic.  For each team, the league wants to keep track of all of the players who have ever played on the team, including the current players.  For each player, it wants to know about the player’s name, age, and every team the player ever played for.

Currently and historically, each team has and has had many players.  To be of interest to the league, a player must have played on at least one and possibly many teams during his career.

The league wants to keep track of each team’s team number, which is unique, its name, the city in which it is based, and the name of its manager. 

Coaches have a name (which is only assumed to be unique within its team) and a telephone number.  Coaches have units of work experience, which are described by the type of experience and the number of years of that type of experience.  A coach works for only one team.  A team has at least one and usually several coaches.

Bats are described by their serial numbers (which are only unique within a team) and their manufacturer’s name.  Each team owns at least one and generally many bats.

Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Fundamentals of Managing data
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education