Build an e-r model for the database of a company

Assignment Help Computer Engineering

Reference no: EM132178421

We want to build an Entity-Relationship model for the database of a company which manages the concerts.

A concert for musical works takes place in a hall at a given date. Several musicians play in a concert and everyone has a role.

We also know the authors of a musical work by their last names and first names.

Concert halls are located in different buildings, each one has an address in the form of a number and a street name and can have several concert halls.

For each room, we know its capacity by counting the seats, all the seats being in the same category.

Several musical works may be presented at each concert. Seat reservations are dated and are referenced by the phone numbers of people who made them.

Each seat reservation is for a single concert. Give an Entity-relationship diagram of this application. Deduce the relational schema of the corresponding database.

Reference no: EM132178421

Questions Cloud

What is the probability of getting a sum : An experiment is rolling two fair dice. What is the probability of getting a sum of 3 or sum of 8?

Write the sample space : a. Write the sample space. How many outcomes are there in the sample space?

How can we model this problem as a graph problem : Suppose we want to fewest number of classrooms required to accommodate all classes. How can we model this problem as a graph problem?

Displays the basic topology for your selected organization : Displays the basic topology for your selected organization. Include routers, switches, and all of the basic network connection hardware.

Build an e-r model for the database of a company : Concert halls are located in different buildings, each one has an address in the form of a number and a street name and can have several concert halls.

What are the possible inputs to your ai system : You want to incorporate Artificial Intelligence (AI) in CPRI system so that CPRI capacity can adjust itself based on the changing user traffic.

How does the use of the cmm help to dissect : How does the use of the CMM help to dissect the primary organizational requirements for achieving enhanced analytical capabilities?

List and describe various types of nonvolatile memory : List and describe various types of nonvolatile memory. Which ones do you think are generally used in PLCs?

Develop an html web page to get four numbers : 1. Develop an HTML web page to get four numbers. You also need to set the background color to the blue with an external CSS.

User Account

All Pages