What is the difference between Logical and Physical Database Model? - ProProfs Discuss
Topics
Products
Follow Us:

What is the difference between Logical and Physical Database Model?

Asked by G. GRAY, Last updated: Mar 30, 2020

+ Answer
Request

1 Answer

Chris Kenway

Chris Kenway, Content Writer, Jacksonville

Answered Mar 27, 2020

A logical data model describes the information and relationships in detail and at an impressive level. It is not studied how data is represented physically in the database. It does, however, describe it at a very abstract level. The logical data model includes both foreign and primary keys. The relationships between entities are controlled with keys.

A logical data model is autonomous of the database control system, as it does not depict the physical structure of the real database. The physical data model is created from the logical data model. Tables are used to compare relationships. Then these relationships are converted to foreign key constraints., and then the attributes are converted to columns of each table.

It describes the physical structure or the database, and the physical data model is dependent on the database system used. It includes tables, columns, data, foreign and primary key constraints, stored procedures, and triggers.

 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.