Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Q. For Ex 2, can you give some hint about the E/R diagram on the games, teams, pitchers? A. Here is a fragment from my

image text in transcribed
Q. For Ex 2, can you give some hint about the E/R diagram on the games, teams, pitchers? A. Here is a fragment from my solution. Plays is a three-way relationship. The Teams entity set participates twice, as home and as away team. runs1, hits1, errors 1 are scores for the home team. runs2, hits2, errors2 are scores for the away team. We don't need to record the winning team; it can be inferred from runs 1 and runs2. Also, no need to distinguish between finished and ongoing games

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

Visual C# And Databases

Authors: Philip Conrod, Lou Tylee

16th Edition

ISBN: 1951077083, 978-1951077082

More Books

Students also viewed these Databases questions

Question

Define Scientific Management

Answered: 1 week ago

Question

Explain budgetary Control

Answered: 1 week ago

Question

Solve the integral:

Answered: 1 week ago

Question

What is meant by Non-programmed decision?

Answered: 1 week ago