Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please with with this question and to who ever this concern, know that your help is greatly appreciated. thank you for your time and consideration.

please with with this question and to who ever this concern, know that your help is greatly appreciated. thank you for your time and consideration.
image text in transcribed
Answer all questions Total Points: 45 1. Draw an entity-relationship diagram that describes the following business environment. 10 Points Lucky Rent-A-Car's business environment is obviously, centered on its cars. A car was manufactured by exactly one manufacturer. A manufacturer manufactured at least one and generally many of Lucky's cars. A car has had many maintenance events (but a brand new car may not have had any, yet.) A car may not have been rented to any customers (again, the case of a brand new car) or to many customers. A customer may have rented many cars from Lucky, and to be in Lucky's business environment must 2. Draw an entity-relationship diagram that describes the following business environment. 10 Points The Super Baseball League wants to maintain information about its teams, their coaches, players, and bats. The information about players is historic. For each team, the league wants to keep track of all of the players who have ever played on the team, including the current players. For each player, it wants to know about every team the player ever played for. On the other hand, coach affiliation and bat Information is current only. The league wants to keep track of each team's team number, which is unique, its name, the city in which it is based, and the name of its manager. Coaches have a name (which is only assumed to be unique within its team) and a telephone number. Coaches have units of work experience, which are described by the type of experience and the number of years of that type of experience. Bats are described by their serial numbers (which are only unique within a team) and their manufacturer's name. Players have a player number that is unique across the league, a name and an age. A team has at least one and usually several coaches. A coach works for only one team. Each coach has several units of work experience or may have none. Each unit of work experience is associated with the coach to whom it belongs. Each team owns at least one and generally many bats. Currently and historically, each team has and has had many players. To be of interest to the league, a player must have played on at least one and possibly many teams during his career. Further, the league wants to keep track of the number of years that a player has played on a team and the batting average that he compiled on that team

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

SQL Antipatterns Avoiding The Pitfalls Of Database Programming

Authors: Bill Karwin

1st Edition

1680508989, 978-1680508987

More Books

Students also viewed these Databases questions

Question

What is Change Control and how does it operate?

Answered: 1 week ago

Question

How do Data Requirements relate to Functional Requirements?

Answered: 1 week ago