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

The beauty of data modeling is that you can take the same information and show it at different levels of detail depending on the audience. In this book we discuss three levels of detail: conceptual, logical, and physical. Entities exist at all three levels.

For an entity to exist at a conceptual level, it must be both basic and critical to the business. What is basic and critical depends very much on the concept of scope. At a universal level, there are certain concepts common to all companies, such as Customer, Product, and Employee. Making the scope slightly narrower, a given industry may have certain unique concepts. Phone Number, for example, will be a valid concept for a telecommunications company, but perhaps not for other ...

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