Skip to content

Chinook is a sample database available for SQL Server, Oracle, MySQL, etc. It can be created by running a single SQL script.

License

Notifications You must be signed in to change notification settings

cwoodruff/ChinookDatabase

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

20 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

ChinookDatabase

Project Description

Chinook is a sample database available for SQL Server, Oracle, MySQL, etc. It can be created by running a single SQL script.

What is New?

Supported Database Servers

  • DB2
  • EffiProz
  • MySQL
  • Oracle
  • PostgreSQL
  • SQL Server
  • SQL Server Compact
  • SQLite Data Model
  • Firebird

The Chinook data model represents a digital media store, including tables for artists, albums, media tracks, invoices and customers. You can see the Chinook data model here. Sample Data

Media related data was created using real data from an iTunes Library. It is possible for you to use your own iTunes Library to generate the SQL scripts, see instructions here. Customer and employee information was manually created using fictitious names, addresses that can be located on Google maps, and other well formatted data (phone, fax, email, etc.). Sales information is auto generated using random data for a four year period. Why the name Chinook?

The name of this sample database was based on the Northwind database. Chinooks are winds in the interior West of North America, where the Canadian Prairies and Great Plains meet various mountain ranges. Chinooks are most prevalent over southern Alberta in Canada. Chinook is a good name choice for a database that intents to be an alternative to Northwind.


About

Chinook is a sample database available for SQL Server, Oracle, MySQL, etc. It can be created by running a single SQL script.

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published