an alternative tables model

This is the code i got from the ER model in the MySQL workbench. I replaced the foreign keys by regular ones bcs somehow SQL doesn't accept more than one foreign key. If you want to execute the SQL code, you'll have to replace 'mydb' by 'dmdb2014'