Tutorials: Logical and Physical Modeling
Go Up to Introduction
ER/Studio Data Architect supports both logical (non-DBMS or technology-specific) modeling and physical (DBMS-specific) modeling. ER/Studio Data Architect is designed to allow organizations the flexibility to analyze and design a business problem or application logically and generate as many different physical interpretations from the logical model as required.
Multiple physical models can be generated from the logical model for the same DBMS (for example, Oracle) or other DBMSs (such as Oracle, SQL Server and DB2). Generating logical and physical models will be discussed in detail in the following sessions.
- Using Data Dictionary Domains to Populate New Entity
- Establishing Relationships Between Entities
- Creating and Working with Submodels
- Generating Physical Models from a Logical Model
- Denormalizing the Physical Model
- Finding out How an Entity Maps to the Physical Model
