O'Reilly logo

Data Modeling Made Simple with ER/Studio Data Architect by Steve Hoberman

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

In ER/Studio, it is wisely assumed that a physical data model cannot be created from scratch, but instead must be based upon an existing logical data model or reverse engineered from an existing database (such as the actual database or a data definition language such as SQL). We’ll go into both approaches in this section.

To design the most effective data model possible, create the logical design before the physical design. The logical data modeling process will bring up important inputs to design that will lead to a more efficient and supportable physical data model and therefore database.

The Generate Physical Model Wizard in ER/Studio automatically ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required