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 ...

Get Business Intelligence Cookbook: A Project Lifecycle Approach Using Oracle Technology now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.