IT

Question 1

Physical, logical, conceptual data model

Answer 1

Physical data model
- the actual blueprint for data model design.
- helps in visualizing database structure by replicating database
column keys constraints, indexes, triggers and other RDMBS
(relational, database management system) features

Logical data model
- designed independent of the DBMS (database management
system) and sets the relationship between data elements

Conceptual data model
- developed independently of the data storage capacity