logical data model vs. physical data model diff

 

 

	Logical data model	Physical data model
Platform-dependent database	No.	Yes.
Data structure	Entities, attributes, PKs, and FKs.	Database tables, rows, PKs, FKs, and data types.
Programmatical features	No.	Triggers and stored procedures.
Objective	Visualize business logic with data structures.	Organize data structure for database design.
Creators	Business analysts and data architects.	Software developers, programmers, and database administrators.
Complexity	Simple.	Complex.
When to use	To understand enterprise systems and business rules.	To plan, implement, and optimize data storage when you’re developing applications.