Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Create a complete Entity-Relationship (ER) diagram for a database that stores the following information about a baseball league. You should model the Entities and their

Create a complete Entity-Relationship (ER) diagram for a database that stores the following information about a baseball league. You should model the Entities and their attributes, as well as the Relationships and their constraints. Write both the minimum and maximum participation of entities in a relationship as explained in class: for example, if a constraint states that a minimum of 2 and a maximum of N entities can participate in the relationship, write 2:N (not just N).

* The database stores information about players, teams, and games. A player has a unique player name. A team has a unique team name. A game has a unique game number. These are the only entities in the database.

* A player plays for one team at any given time. The start date and end date for the players assignment on the team is recorded. A team will consists of 9 or more players.

* The database keeps track of every time a player participates in a game. It also stores the players performance rating (A,B,C,D,F).

* For each game, there will be one home team and one away team. The date, time, and field name will be recorded for each game.

* For each game, the Inning Score for the home team and the away team will be stored. The Inning Score consists of: the number of runs, hits, and errors. The Final Score of the game will be also be stored for both the home team and the away team (runs, hits, and errors)

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_2

Step: 3

blur-text-image_3

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

Pro Oracle Fusion Applications Installation And Administration

Authors: Tushar Thakker

1st Edition

1484209834, 9781484209837

More Books

Students also viewed these Databases questions