Create an Entity Attribute Relationship $($EAR$)$ Diagram

Create a Relational Schema

Create the Data Dictionary

Create Tables in MySQL and load test data

Please examine the following scenario $-$

Business: Local Movie Theater

A local movie theater would like for their customers to purchase movie tickets on$-$line. They should be

able to login with their ID and Password. View movies, show times and prices. Once they select a

movie at a particular time they can purchase a ticket$($s$).$

Assumptions $-$ This movie theater has $200$ seats available per show time. Ticket prices may vary

depending on show time.

Review the instructional video for more information.

Optional: We need to save each transaction $($Historic Data$)$ for each purchase.

Create an Entity Attribute Relationship $($EAR$)$ Diagram using app.diagrams.net

Please use Chen notation when doing ERD