For a concert management company, there are multiple venues for performances in the US. The concert management company hires multiple performers. Each performance venue hosts many concerts a year. Performers perform several times a year for concerts. Each concert has one or more performers, a name, and a specified seating arrangement. A concert is held in one (and only one) of several concert halls, each of which has a hall number and the type and number of seats. Each concert generates revenues from the sales of tickets. Assume that the price of the ticket is the same for the same concert, but different prices for different concerts. Identify several 2 attributes and a key field for each entity. Represent this situation with an E-R diagram. State assumptions if any.
For a concert management company, there are multiple venues for performances in the US. The concert management company hires multiple performers. Each performance venue hosts many concerts a year. Performers perform several times a year for concerts. Each concert has one or more performers, a name, and a specified seating arrangement. A concert is held in one (and only one) of several concert halls, each of which has a hall number and the type and number of seats. Each concert generates revenues from the sales of tickets. Assume that the price of the ticket is the same for the same concert, but different prices for different concerts. Identify several 2 attributes and a key field for each entity. Represent this situation with an E-R diagram. State assumptions if any.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images