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 workbench, 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
- Create
a physical model by transforming from a logical data model