Lab 2 (Continuation of Lab 1) Solution

Please make sure you have completed Lab 1 before you start Lab 2.

In this lab you will create the SQL tables for the six entities from Lab 1. Make sure you specify appropriate primary key and referential integrity constraints. Populate the databases with sample data. Execute select * statements to make sure everything works.

To connect to mysql server:

mysql -h toshikuboi.net -u your_user -p