ClassicModels

ClassicModels

The schema is for Classic Models, a retailer of scale models of classic cars. The database contains typical business data such as customers, orders, order line items, products and so on.

Original source: www.mysqltutorial.org

Versions

  • Classicmodels (by Jan Motl)

Dataset details

Associated task:
Regression
Domain:
Retail
Data types:
Size:
500 KB
Count of tables:
8
Count of rows:
3,864
Count of columns:
59
Missing values:
Yes
Compound keys:
No
Loops:
No
Type:
Synthetic
Instance count:
273
Target table:
payments
Target column:
amount
Target ID:
checkNumber
Target timestamp:
paymentDate

How to download the dataset

The datasets are publicly available directly from MySQL database.

  1. Open your favourite MySQL client (for example MySQL Workbench)
  2. Use following credentials:
    • hostname: relational.fit.cvut.cz
    • port: 3306
    • username: guest
    • password: relational
  3. Export "classicmodels" database (or other version of the dataset, if available) in your favourite format (e.g. CSV or SQL dump).