Online Movie Database

We will create a database to store information about movies and movie theaters. We will have tables
describing movies, actors, directors, theaters, screens, show times, tickets and theater staffs. In addition, we
will have several relation tables that describe the complex interrelations between these objects. Your
assignment is to create the tables and relations along with all the specified constraints, and populate the
tables with at least two records in each table. You also have to provide answers to the questions listed at
the end.
Deliverables:
1. One SQL script file containing all the table creation statements, constraint specification statements and
data insertion statements. (25 points)
2. The front end project files (HTML, java, C#, etc.)

1. The client program should select data in the every table.
2. The client program should insert and delete data in the Movie, Screen, and Ticket table