Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the following information about a baseball legend: Teams have a TID and a name Players have a name and an age Pitchers are a

Consider the following information about a baseball legend:
Teams have a TID and a name
Players have a name and an age
Pitchers are a type of Players. Each pitcher has attributes W (win games), L (loss games),
and ERA (earned run average)
Batters are a type of Players. Each batter has attributes AVG (batting average) and HR
(home runs)
Each player plays for exactly one team; a team can have many players
Each player has exactly a contract relationship with his team, and a contract contains years
and salary.
Games have a date (on which the game was played) and a score (e.g.,3:2)
A game has exactly a winning team and has exactly a losing team; A game can be uniquely
identified by its winning team, losing team, and the date.
Identify the Entity, attributes and draw the ER diagram.

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

Spatial Databases With Application To GIS

Authors: Philippe Rigaux, Michel Scholl, Agnès Voisard

1st Edition

1558605886, 978-1558605886

Students also viewed these Databases questions

Question

Find the sine and cosine of the angle 0. y sin(0) = 6 10 (8,6) X

Answered: 1 week ago