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

 We want to build an Entity-Relationship model for the database of

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!