Question: Please create an E/R data madel based on the following relationships: events are uniquely identified by a three-letter code, they have a title, and are

Please create an E/R data madel based on the following relationships: Please create an E/R data madel based on the following relationships: events

events are uniquely identified by a three-letter code, they have a title, and are scheduled to happen during a particular season (Fall, Winter, Spring, or Summer), at a specific year, the company organizes events at different venues (theaters, stadiums, etc.) uniquely identified by a venue identification number and they each have a name; for ticketing purposes, each event venue is divided into sectors and each sector has a number of available seats; for each event, all seats at a particular location belonging to a sector share the same sell price customers are uniquely identified by an auto-generated identification number, they have a name, phone, credit card, and billing address: a customer can book one or more seats for a particular day and time of an event. After some thinking, you came up with the following E/R Data Model

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!