An event management company wants to automate its ticketing system. you are hired to create the data model for them. While meeting with your client you took the following notes:

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.

Derive a relational schema from your E/R Diagram (ERD) above, describing the relations, attributes, key attributes, and domains.

sen Var Events happe Venues divided in happens on IC de Event Days Sectors PM se Sacs Customers