Data Model Examples

Here is an example that can help you understand the power of a well documented database.

The Book Database

Logical Data Model – This helps the Business Analyst communicate with both the business and the technical representatives.

Physical Data Model – This is represents the actual data structures that gets implemented in the database.

The OLTP Orders example from XDC 2015

Logical Data Model

Physical Data Model

DDL – For a PostgreSQL database.

Recent Posts

Recent Comments