The Sakila database has four major modules within it: Inventory
, which consists of the information about films along with inventory information (the number of movies available for rental in each store);
Customer Data
, which consists of customer information;
Business
, which consists of the stores, staff, rental, and payment information (it 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...