Physical data models are used to describe how the data is stored at the lowest level.
The physical data model shows in diagram form, the actual representation of the physical tables and views in a database and the relationships between them. Instead of using the more English-like business names for the tables, shorter abbreviated physical table names are used (i.e., â€œT_PERS_HISTâ€ instead of â€œPerson Historyâ€). Because it shows the actual table names, the physical model is a key reference when writing queries directly against the database. ()
A formal representation of data and their relationships in the form of a diagram, depicting the physical placement of data in a database. A physical data model is process dependent, which means that it is denormalized to provide maximum performance efficiency. It is commonly referred to as logical database design or database design schema.