Total Data Modeling

The Art and Science of Information Management

Physical Data Modeling

An activity that includes producing a Physical Data Design Model, or Physical Data Model (PDM) that shows the business attributions translated into View and Table columns, and the relationships translated into Referential Integrity constraints. The model shows the columns, their data format, their optionality and their key contributions. The PDM graphically represents a DBMS oriented design solution to the data requirements within scope, which can be implemented in a database.

This is a modeling activity that pre-exists TDM. The TDM activities that precede this one insures of its stability and provides very high confidence in meeting the business objectives. The Views that are created from the Forms reduce the amount of program coding necessary to the application construction.