Forward Engineering Tutorial
I created a short video tutorial on how to forward engineer a database on the SRJC student server. The first few seconds are gray for some reason, but stick with it and you’ll see the step by step method for creating the database objects:
http://youtu.be/1sqhDJae-xY?hd=1
Essentially, you need to choose the options in the Forward Engineering wizard so that the tables are created in your default schema – which is generally your first initial and first 7 characters of your last name. Remember to insert the use SCHEMA statement into the sql script prior to executing it.
Data Modeling Resources
Very good tutorial on UML & Data Modeling
http://www.tomjewett.com/dbdesign/dbdesign.php
The definitive book from one of the creators of relational databases.