What is the difference between Logical and Physical Database Model? - ProProfs Discuss
Cancel
TopicsDown
Products Down
Follow Us:
FacebookTwitter
Advertisement

What is the difference between Logical and Physical Database Model?

Asked by G. GRAY, Last updated: Sep 28, 2020

+ Answer
Request
Question menu
Vote up Vote down

1 Answer

Chris Kenway

Chris Kenway

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.

upvote downvote
Reply 

Advertisement
Advertisement
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader
Image Preview
Search for Google images Google Image Icon
Select a recommended image
Upload from your computer Loader

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