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
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
Get step-by-step solutions from verified subject matter experts
