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 physical data model (PDM) is the logical data model compromised for specific software or hardware. On the CDM, we learn what the terms, business rules, and scope would be for a new order entry system. After understanding the need for an order entry system, we create a LDM representing the business solution. It contains all of the attributes and business rules needed to deliver the system. For example, the conceptual data model will show that a Customer places many Orders. The LDM will capture all of the details behind Customer and Order, such as the customers name, their address, and the order number. After understanding the business solution, we move on to the technical solution and build the PDM. We may ...

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