Chinook Database - Versions 1.1 to 1.3 (Current Release)

Chinook Database - Version 1.0

Last edited Nov 15, 2010 at 4:14 AM by lerocha, version 9


MoDraXm May 31 at 5:58 AM 
To respond to @agowtham, you'll need to have an instance of MSFT SQL Server, Postgree SQL, Oracle, or MySQL running. Upon extraction, you'll open up the corresponding .sql file and run it as a script. If you look in the .sql files you'll see they contain the script for creating new tables, as well as dumping the data. So once started the queries take a few minutes to process and complete.

agowtham Sep 4, 2012 at 9:38 AM 
After i download the database how do i connect to the database..i dont see it

stevedln Dec 22, 2009 at 5:54 PM 
Both versions of the schema above are not properly normalized. There is the potential for redundant data in the Customer, Invoice, and Employee tables regarding address, city, state, country etc. There is no way to track when a record was created or modified; if applicable.