Creating a physical data model
A physical data model is a database-specific model that represents relational data objects (for example, tables, columns, primary and foreign keys) and their relationships. A physical data model can be used to generate DDL statements which can then be deployed to a database server.
Using the data tooling, you can create a physical data model in several ways:
| Create a blank physical model by using a wizard.
|
|
| Create a physical model from a template by using a wizard.
|
|
| Reverse engineer a physical model from a database or a DDL file by using a wizard or by dragging data objects from the Database Explorer.
|
|
| Import a physical data model file from the file system.
|
In this section, we show you two ways to create the physical data model. First we create a physical data model by reverse engineering the model from an existing database ITSOBANK. Then we create a new physical data model from a template and deploy this new model to the database.