Entity Relationship Model

Physical Data Model

Physical Data Model is used to define an Application's Database Structure with Database Space, Segment, Block, Partition, Abbreviation, Glossary, Table, Column, Domain Type, Domain Size, Domain Constraint, Key Constraint, Referential Integrity Constraint, Stored Procedure, Trigger, Function and Index Data Objects.

Physical Data Model is an extension of Logical Data Model that helps to create Physical Database Structure. Physical Data Model can transform into Database Report and SQL Script File through CASE Tool Application.

Database Report is used to analyze Database Structure and Optimize Database Operation.

The following Physical Data Model is defines an "Online Sales Management System".

* * * * *

Email Your Comment To AUTHOR