The Chinook database is a sample database available for many DBMS platforms. It represents a digital media store, with data such as albums, artists, tracks and invoices.

An entity-relationship diagram for the Chinook sample database is here:

For demonstration purposes, we provide a SQLite version of Chinook and a simple star schema that supports analysis of sales by date, location and track.

Database Location

The Chinook sample database may be found in the following location:

Microsoft Windows:


Linux and OSX


Next Steps

Logon to Ajilius, and open the metadata for the sample data warehouse.

Open metadata