This tutorial teaches you how to transform a logical
data model into a physical data model, using different transformation options
for denormalization.
Learning objectives
When
you complete the exercises, you will know how to do the following tasks:
- 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
60 minutes