Design the corresponding er diagram

Reference no: EM133575763

Develop the E/R diagram for a database for NBA games. 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.

Question: 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.
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.

Reference no: EM133575763

Questions Cloud

Describe how you would identify and manage risks for this : describe how you would identify and manage risks for this project. Specifically indicate who you would include in the risk processes and when you would conduct

Compare numeric and string : Compare numeric and string/text data types between R and Python. Please include links to all the websites you used for your research

How learning theories are applied in an online learning : How learning theories are applied in an online learning environment, and where in the instructional design model these theories are considered.

Why is this analysis critical to supplier development : systematic expansion of the cost elements, determination of the cost drivers and the development of insights. Why is this analysis critical to supplier

Design the corresponding er diagram : Design the corresponding E/ER diagram. Remember to include arrows representing cardinality where relevant. Underline key attributes and identify foreign keys

How do ineffective hiring practices and ethical standards : How do ineffective hiring practices and ethical standards affect culturally diverse employees' motivation and performance in public administration?

Describing your personal feelings : Analyze this statement, describing your personal feelings and giving an example of this philosophy

Which of the following is notcorrect about wellness : Which of the following is notcorrect about wellness?

Identify what you believe to be the most difficult challenge : identify what you believe to be the most difficult challenge to ethically balance with CSR initiatives over the long term. Keep in mind that CSR efforts can

User Account

All Pages