Physical Data Model

by Amol 20. February 2011 10:57

Physical Data Modeling:

The next step after Logical Data Model is to generate Physical Data Model. Physical data model is generated from the approved Logical Data Model.

Logical and Physical data model looks same but having some major differences between them. Such as Physical Data Model includes all required database objects like tables, columns, Keys, relationships, database properties for the physical implementation of databases. Some of the important parameter of Physical Data Model are database performance, indexing strategy, physical storage and normalization, denormalization

Once Physical Data Model is completed, it is then forwarded to technical teams for review and implementation.

In the figure below, the entity names has been changed to table names, changed attribute names to column names, assigned nullability constraints, and datatype for each column.


Data Modeling

Tag cloud