RDB Design Assignment

Consider the following case:

A university needs a database for events on campus. An event has a date, time and a title and possibly a subtitle. An event also has associated ticket costs and ticket costs can be tiered based on whether the purchaser is a student, on staff at the university, or a faculty member, alumni, or emeritus faculty, or some other arbitrary category of ticket. So a ticket has a tier identification, a tier name and an associated costs. The database design must be able to manage the variable nature of ticket tiers.

An event also has one or more performers. The performer has a name and a description.

An event has a venue (where the event will be held). The venue has a name, an address, and a maximum number of seats that can be sold.

An event has prospective attendees, those who may be attending the event (they have purchased a ticket). These attendees optionally have an assigned seat in the event venue.

Tasks

Create a database design with one or more tables in 3NF. Use the MySQL Workbench to create an ER diagram. Note: You must export this diagram to PNG or PDF formatted document and submit that document for this assignment.