reviewed schema from book http://codex.cs.yale.edu/avi/db-book/db6/lab-dir/sample_tables-dir/DDL.sql. Fixed incorrectly formed foreign keys causing errors in mysql