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.
Answer Anonymously
Copy Link
