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. |
