Tech moves fast! Stay ahead of the curve with Techopedia!
Join nearly 200,000 subscribers who receive actionable tech insights from Techopedia.
A physical data model defines all of the logical database components and services that are required to build a database or can be the layout of an existing database.
A physical data model consists of the table’s structure, column names and values, foreign and primary keys and the relationships among the tables.
A physical data model primarily defines all the relational data models and objects of the database. It is created using the native database language of the database management system (DBMS). It can also be created by transforming the logical model. A physical data model is used by database administrators to estimate the size of the database systems and to perform capacity planning. The physical data model constraints such as size, configuration and security can vary based on the underlying database system.