How to forward engineer your logical data model to a relational data model
Forward engineering converts logical entities into physical tables which can be installed onto the database.
Getting ready
Ensure all your entities and attributes have been named correctly, domains assigned, and all the additional columns have been added before you forward engineer your logical model.
How to do it...
Forward engineering is a top-down approach to developing your physical data model. Using a data modeling tool to develop the data model is more efficient and easier to maintain than using the limited capabilities of your Extraction, Transformation, and Loading tool, such as OWB:
1. Click on Design | Engineer to Relational Model:
2. Deselect all objects by clicking on the checkbox located to the left-hand side of the Logical node in the tree. Select the relational model from the drop-down list in the top-right panel. Select the necessary Entities by clicking on the checkbox next to the entity name. Then,...
