Develop the E/R diagram for a database for NBA games. For now, we'll focus on only...

  

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?

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