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

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.

title season code year name Events happens at Venues divided in happens on price date time Event Days has price sector Sectors #seats has buys seata id Seats Customers name CC addr phone