MySQL Sakila Sample Database

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.