Develop the E/R diagram for a database for NBA games. For now, we'll focus on only...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Develop the E/R diagram for a database for NBA games. For now, we'll focus on only a few aspects of the database. Later parts of this assignment will expand the database. The database should incorporate information about the teams, stadiums, and games. The database contains information about each team's unique name, location, and total salary and adds two more attributes. Information about stadiums includes the unique name, capacity, year built, and add 2 more attributes. Stadiums are either dedicated only to NBA games or may have a different sport played in them. For example, many basketball stadiums also host hockey games. Only for those dedicated to the NBA, the database includes information about the price of nachos and drinks. For those that are dual use (and have another sport), the database maintains information about the other sport, the capacity for the other sport, and the average ticket price for the other sport. A game is played in a stadium and has two teams. The home team and the away team. For each match, the database maintains information about the date of the game, teams, and each team's score. The same pair of teams may play each other more than once. Design the corresponding E/ER diagram. Remember to include arrows representing cardinality where relevant. Underline key attributes and identify foreign keys. Note: think about how to require both a home team and an away team in the E/R diagram. i. Also, convert the diagram to relations. In other words, show the tables used in the database. You do not need to include data, only the structure of the tables. ii. Suggest three queries that you could ask of this database. iii. Suggest 1 query that requires additional attributes. Which attributes are needed to answer this further query? Develop the E/R diagram for a database for NBA games. For now, we'll focus on only a few aspects of the database. Later parts of this assignment will expand the database. The database should incorporate information about the teams, stadiums, and games. The database contains information about each team's unique name, location, and total salary and adds two more attributes. Information about stadiums includes the unique name, capacity, year built, and add 2 more attributes. Stadiums are either dedicated only to NBA games or may have a different sport played in them. For example, many basketball stadiums also host hockey games. Only for those dedicated to the NBA, the database includes information about the price of nachos and drinks. For those that are dual use (and have another sport), the database maintains information about the other sport, the capacity for the other sport, and the average ticket price for the other sport. A game is played in a stadium and has two teams. The home team and the away team. For each match, the database maintains information about the date of the game, teams, and each team's score. The same pair of teams may play each other more than once. Design the corresponding E/ER diagram. Remember to include arrows representing cardinality where relevant. Underline key attributes and identify foreign keys. Note: think about how to require both a home team and an away team in the E/R diagram. i. Also, convert the diagram to relations. In other words, show the tables used in the database. You do not need to include data, only the structure of the tables. ii. Suggest three queries that you could ask of this database. iii. Suggest 1 query that requires additional attributes. Which attributes are needed to answer this further query?
Expert Answer:
Answer rating: 100% (QA)
Heres a short Python program to determine the value of n based on the given arrangement of passengers passengers 0 0 0 0 0 1 1 1 1 0 0 1 1 0 1 0 0 for n in range1 lenpassengers circle passengerscopy i 0 while lencircle 15 index i n 1 lencircle if circleindex 1 break del circleindex i index if lencircle 15 printThe value of n is n break Explanation of Code 1 Looping through possible n values The program starts by checking n from 1 onwards as it needs to begin counting from the first passenger ... View the full answer
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these databases questions
-
During the drug research process what group must review the results of animal research studies before human trials will be allowed to begin in the US.
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Read the case study and answer the question below with a one page response. What does a SWOT analysis reveal about the overall attractiveness of Under Armours situation? Founded in 1996 by former...
-
Determine the tax basis of the business asset acquired in each of the following cases: a. Firm L paid $5,950 cash plus $416 sales tax plus a $500 installation charge for a satellite dish. b. TTP Inc....
-
Doctors treated a patient at an emergency room from 2:00 P.M. to 7:00 P.M. The patient's blood oxygen level L (in percent) during this time period can be modeled by L = 0.270t2 + 3.59t + 83.1, 2...
-
Several automobile manufacturers are beginning to implement programs for build-to-order cars. Identify an auto company that has initiated a BTO program and describe what it entails. Contrast the BTO...
-
In reporting on compliance with laws and regulations, what does the GAO's Government Auditing Standards require an auditor to report?
-
Clark Bell started a personal financial planning business when he accepted $36,000 cash as advance payment for managing the financial assets of a large estate. Bell agreed to manage the estate for a...
-
Cull Corporation uses a job-order costing system with a single plantwide predetermined overhead rate based on machine-hours. The company based its predetermined overhead rate for the current year on...
-
Identify the fallacies committed in the following dialogue. You should be able to find at least one case of each fallacy presented in this section. Food for Thought "Let's hit the produce section...
-
When 10 British Army soldiers on a 10-day training exercise descended into Low's Gully, a narrow chasm that cuts through Mt. Kinabalu in Borneo, each knew "the golden rule for such expeditionsnever...
-
This extract describes Kerry Foods, an Irish company producing a range of foodstuffs. The best performance came from the food ingredients division, which made a profit of A257m, up 17.5%, with...
-
What are the primary, general sources of collective, inferential errors?
-
How do group members short-circuit conflict spirals?
-
Why does confirmation bias lead to defective decision making/problem solving?
-
You are the accountant of Hill Ltd (Hill), an electrical retailer having a chain of shops. Hill has recently acquired two other similar businesses. The sales director has come to you with a problem...
-
Use Euler's method/Modified Eulers' method to solve the following: a. y' = xy, y(0) = 1 b. y' = 1+ y,y(0) = 0
-
Describe the Operations (+,,*,/) that can cause negligible addition (NA), error magnification (EM), or subtractive cancellation (SC) in calculating ?((x^2)+1) - x . Give the range of where they might...
-
Doctors Information Technology (DocIT) is an IT services company supporting medical practices with a variety of computer technologies to make medical offices more efficient and less costly to run....
-
State two conditions that indicate when a database designer should consider using supertype/subtype relationships.
-
List five disadvantages of file processing systems.
-
For methanol synthesis reaction \[ \mathrm{CO}(\mathrm{g})+2 \mathrm{H}_{2}(\mathrm{~g}) ightleftharpoons \mathrm{CH}_{3} \mathrm{OH}(\mathrm{g}) \] Using a feed mixture of carbon monoxide and...
-
The L2 steel blade of the band saw wraps around the pulley having a radius of \(12 \mathrm{in}\). Determine the maximum normal stress in the blade. The blade has a width of 0.75 in. and a thickness...
-
An L2 steel strap having a thickness of 0.125 in. and a width of \(2 \mathrm{in}\). is bent into a circular arc of radius \(600 \mathrm{in}\). Determine the maximum bending stress in the strap.
Study smarter with the SolutionInn App