Learning objectives
This tutorial is divided into several exercises that you must complete
in sequence. This tutorial teaches you how to transform a logical data
model into a physical data model. While completing the exercises, you will:
- Import a sample data design project that contains a domain model and a
logical data model
- Associate the domain model with the data design project to use
it as the standard for the project
- Transform the logical data model to a physical data model
- Modify logical data model properties by using a diagram and the Properties
view
- Transform the logical data model to a new physical data model and observe
how your changes affect the physical model
- Modify a physical data model to add an index and generate a DDL script
to capture your changes
This workbench functionality satisfies the following enterprise data modeling
requirements:
- Transforming an abstract entity model to a concrete database model
- Enforcing data type consistency and naming standards by using a reusable domain model
- Consolidating the subtasks of modeling in a team environment
- Merging and managing incremental changes
Time required
To complete this tutorial, you will need approximately
1 hour . If you decide to explore other facets of data design and modeling while
working on the tutorial, it could take longer to finish.
Prerequisites
In order to complete this tutorial end to end, you should be familiar with the following concepts:
- Database design
- Logical data modeling
- Physical data modeling
It will also help if you understand how to
use the perspectives and views of the workbench.