Answered step by step
Verified Expert Solution
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 eg:
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started