Java language

1 & 2 Delieverables

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.). (60 points) 3. The project report document. (15 points) Requirements 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 Table: Movie Attribute Movield MovieName MovieDescription MovieRatin MovieReleaseDate MovieLen Char(8) Varchar20100 Varchar2(1024) Varchar2(5) Date Number Constraint Pk Not Null Not Null Not Null Not Null Not Null 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.). (60 points) 3. The project report document. (15 points) Requirements 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 Table: Movie Attribute Movield MovieName MovieDescription MovieRatin MovieReleaseDate MovieLen Char(8) Varchar20100 Varchar2(1024) Varchar2(5) Date Number Constraint Pk Not Null Not Null Not Null Not Null Not Null