MySQL Sakila Sample Database

Sakila Sample Database Introduction

The Sakila sample database is a database of MySQL's official simulation DVD rental Information management, providing a standard model that can be used as examples in books, tutorials, articles, samples, and so on, which is a good choice for learning tests.

1.:

MySQL:: Other MySQL documentation https://dev.mysql.com/doc/index-other.html

(Example Databases-to-Sakila database-to-zip package or. tar.gz package)

2, the import data decompression to get 3 files:

SAKILA.MWB Workbench Data Model

Sakila-data.sql Table Record Information

SAKILA-SCHEMA.SQL Table Structure Information

Import two SQL files (import the table structure first, then pour the number; under Linux # source Xx.sql Windows SQLyog Ctrl + Shift +q Execute)

3, Sakila sample database DVD Leasing Business Process Interpretation

The Sakila database mainly describes the business process of the DVD leasing system, where the key points are enumerated to explain how the process works:

• Each store maintains its own list of rental films, and a dedicated clerk maintains the list when the customer takes or returns the DVD disc;
• The content of the film is also maintained in the scope of the information, such as classification (action, adventure, comedy, etc.), actors, grades, special categories (such as deleted episodes and trailers). This information may be printed on the label on the DVD package;
• You must register as a member in the store to rent a CD-ROM;
• Customers can rent one or more discs at any store, while the store wishes to plan the previously leased discs within the rental period for each disc;
• Customers can pay for any leased discs at any time;

4. Data Graph Library Model relationship

For a more detailed description of the Sakila sample database, please refer to the official documentation: https://dev.mysql.com/doc/sakila/en/

Reference:

Using MySQL sample database Sakila http://blog.csdn.net/geekcoder/article/details/8988052

Pentaho Kettle Solutions

Official Document Address: https://dev.mysql.com/doc/

MySQL Sakila Sample Database