📖 The classdb Database

We will be using a sample database in this course called classdb. classdbis an open source database that can be downloaded and used for free.

The full database is quite large, so I have created a truncated version of the classdb database that will download and install more quickly for our use in this course. Click on the link to download the file. You can then unzip the files and use MySQL Workbench to import the database to your own MySQL installation. This database will be used throughout the course.

The image below shows the structure of the database. There are 11 tables. The field names, primary keys and relationships are all shown here. You may use this as a reference for the lab practices and competency assessment.

Chinook Database Schema