Inventory

The inventory database contains the following tables:

The film table

The film table contains a list of all films (logical information), not necessarily in stock. The stock information (physical copy) is in the table inventory described as follows:

Column	Description
film_id	A primary key used to uniquely identify each film in the table.
title	The title of the film.
description	A short description or plot summary of the film.
release_year	The year the film was released.
language_id	A foreign key pointing at the language table; it is used to identify the language of the film.
original_language_id	A foreign key pointing at the language table; it is used to identify the original language of the film. It is only used when a film has been dubbed into a new language.
rental_duration	The number of rental days.
rental_rate	The cost to rent the film for the period specified in the rental_duration column.
length	The length of the film in minutes...