It's time to go to the opera! You are going to use MySQL Workbench's EER tool to create an Entity-Relationship diagram for the Civic Center Opera House. You will then engineer that to produce MySQL script(s) which will create and load the database schema with the information below. Finally, you will query your database to prove it is working.

Here is the relevant information.

• Susie attended Madame Butterfly and spent $25 on the ticket for the 1/11 performance, and then went to see La Traviata on 10/3 for $100. She also went to see Carmen for $30 on 10/10.
• Lee attended Madame Butterfly and spent $25 on the ticket for the 10/21 performance.
• Jackson attended Carmen and spent $30 on the ticket for the 5/12 performance. He also went to see La Nozze di Figaro on 1/20, and paid $100 for the ticket.
• Bobby attended Carmen and spent $30 on the ticket for the 1/26 performance, and then went to see La Boheme on 8/14 for $50.
• Margaret attended La Nozze di Figaro and spent $100 on the ticket for the 2/22 performance, and then went (with Jackson) to see Carmen on 5/12 for $30.
• Ulysses attended Rigoletto on 10/21 and spent $35 on the ticket.
• Each ticket has an option to have a "Backstage Pass" option. There is no additional cost associated with this, just a marking on the ticket that the backstage pass was selected.
• Backstage passes were selected by Margaret at all of her operas, and by Jackson when he went with Margaret to Carmen on 5/12. No other tickets chose a backstage pass.

Additional assumptions you should make:

• Assume all tickets for the same opera cost the same. For example, all tickets for Madame Butterfly are $25.
• All operas occurred last year. For example, if it is 2023 now, and the date says "November 11," assume it was November 11, 2022.

Normalize this database and implement in MySQL Workbench using this information.

Name your database schema "CivicCenter." Please try to use this exact name to make it easier to grade. It is not case-sensitive so it's OK to use "civiccenter" or CIVICcenter." Do not use "Civic_Center" or "civic-center."

You may use as many or as few tables as you see fit.

Your deliverables are:

1. "XXX_Civiccenter_ERD.pdf" where XXX are your initials. This is a pdf of an entity-relationship diagram made using MySQL Workbench's modeling tool (you can find this under File Menu -> Export.) If you have difficulty with the direct export, you are welcome to grab a screen shot and convert that to .pdf by other means (for example, paste your screenshot to a Word document, then .pdf that.)
   1. Entity-relationship diagrams made using other tools will not earn full points.
   2. The diagram should show all entities you use (it's OK to use more than one page if you need to, and you can cobble together screenshots if you need.)
   3. All entities should show all fields and keys; expand the boxes or rearrange them if you need to.
   4. All relationships and cardinalities should be easily visible
   5. All relationships should have text sentence(s) labeling them. For example, if this were the pet database, you might write, "Each pet must have one and only one owner. Each owner may have zero or more pets."
2. "XXX_Civiccenter_create.sql" where XXX are your initials. This is an SQL script which will drop any pre-existing Civic Center schema and create all the tables, keys, and other structures you will need. If we run this script, it should remove any existing civiccenter schema and create yours.
3. "XXX_Civiccenter_insert.sql" where XXX are your initials. This is an SQL script which will insert the problem data into your database.

1. "XXX_Civiccenter_query.sql" where XXX are your initials. This is an SQL script which will run a query on your database and show the results. Write SQL statement(s) which will produce an output table with the following fields in it, sorted with the most expensive tickets at the top, and then alphabetically by customer name:

Name	Opera	Cost	Date	Backstage Pass?

1. "XXX_Civiccenter_export.csv" where XXX are your initials. This is an .csv file export of your "XXX_Civiccenter_query.sql" execution results. You can export this using the "export" icon in the Result Grid window in MySQL Workbench. (Note the data displayed below may or may not correspond to the data in this assignment.)