Java language Delieverables 1 and 2 We will create a database to store informati

Question

Java language Delieverables 1 and 2 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. Th 2. The client program should insert and delete data in the Movie, Screen, and Ticket table e client program should select data in the every table. Table: Movie Attribute Moviel MovieName MovieDescription MovieRatin MovieReleaseDate MovieLen Char(8) Varchar2(100 Varchar2(1024) Varchar2(5) Date Number Pk Not Null Not Null Not Null Not Null Not Null

Explanation / Answer

All the answers cannot be done as this seems to be some project and we have only 2 hour so answering first part of the question:-

SQL Script File :-

CREATE TABLE Movie1 (
MovieID char NOT NULL PRIMARY KEY,
MovieName varchar(255) NOT NULL,
MovieDescription varchar(1024)NOT NULL,
MovieRating varchar(1024)NOT NULL,
MovieReleaseDate Date NOT NULL,
MovieLength int NOT NULL
);

  

Related Questions

Navigate

• Browse (All)
• Browse J
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.