You are required to design and create a database for a movie theatre. You have the...

 

Transcribed Image Text:

You are required to design and create a database for a movie theatre. You have the following information about the way the movie theatre operates: Details of the movies that the theatre has must be recorded. This includes a movie ID number, the name of the movie, its duration in minutes and a description of the movie. The classification of each movie must also be recorded. To do this, the database should contain a table containing the details of classifications as shown below: Classification Name Minimum Age General Not Applicable Parental Guidance Not Applicable Not Applicable 15 18 G PG M MA R Restricted (The Classification column can be used as the primary key of the table) o The movie table will need a foreign key to identify the classification of each movie. Mature Mature Audiences The genres of each movie must also be recorded. The only details you need to store about genres are an ID number and name. Each movie can have multiple genres (but must have at least one), and there can be many movies of the same genre. The database must record details of the cinemas within the movie theatre - i.e., the rooms in which movies are viewed. The details that need to be stored about the cinemas are an ID number, the name of the cinema (e.g. "Cinema 3") and the seating capacity. To allow for better organisation and advertising of sessions, the theatre wants to keep track of their cinema types. Add an entity to store the list of cinema types shown below, and make sure that the cinema entity includes a foreign key to identify the type of each cinema. You are required to design and create a database for a movie theatre. You have the following information about the way the movie theatre operates: Details of the movies that the theatre has must be recorded. This includes a movie ID number, the name of the movie, its duration in minutes and a description of the movie. The classification of each movie must also be recorded. To do this, the database should contain a table containing the details of classifications as shown below: Classification Name Minimum Age General Not Applicable Parental Guidance Not Applicable Not Applicable 15 18 G PG M MA R Restricted (The Classification column can be used as the primary key of the table) o The movie table will need a foreign key to identify the classification of each movie. Mature Mature Audiences The genres of each movie must also be recorded. The only details you need to store about genres are an ID number and name. Each movie can have multiple genres (but must have at least one), and there can be many movies of the same genre. The database must record details of the cinemas within the movie theatre - i.e., the rooms in which movies are viewed. The details that need to be stored about the cinemas are an ID number, the name of the cinema (e.g. "Cinema 3") and the seating capacity. To allow for better organisation and advertising of sessions, the theatre wants to keep track of their cinema types. Add an entity to store the list of cinema types shown below, and make sure that the cinema entity includes a foreign key to identify the type of each cinema.