The sakila database consists of 15 tables including film, film_category, actor, customer, rental, payment and inventory among others. The sakila sample database, which is a fictitious database designed to represent a DVD rental store, is intended to provide a standard schema that can be used for examples in books, tutorials, articles, samples, and so forth.

Our previous book, part 1, implements the first six tables in sakila database: actor, language, film, category, film_category, and film_actor tables. This book, as second part, uses five tables in the sakila sample database: country, city, address, store, and staff tables.