Managing information – films

The Sakila database has four major modules within it: Inventory, which consists of the films' information, along with the inventory information (how many movies we have in each store available for rental); customer data, which consists of customer information; business, which consists of the stores, staff and also rental and payment information (this depends on inventory and customer data to feed some information); and views, which consists of data we can use for reports and charts.

For now, we are only interested in Inventory, customer data, and business, which contains the core business information of the application. Let's take a look at Inventory, which has more tables than the other two:

According to the Sakila documentation:

The film table is a list of all films potentially in stock in the stores. The actual in-stock copies of each film are represented in the inventory table.

The film table refers to the language table and is referred to by the film_category...