Chinook Database Schema

The Chinook database consists of a digital media store, including tables for artists, albums, media tracks, invoices, and customers.

  • Media related data was created using real data from an iTunes Library. 
  • 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.


Below is what the Schema looks like:

Album Table Playlist Table Employee Table

About CodeStencil

CodeStencil is Published and Marketed by Zera Systems Inc.

© 2018-2019 CodeStencil - Zera Systems Inc. All Rights Reserved.

No