Answered step by step
Verified Expert Solution
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
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
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