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
DDL – For a PostgreSQL database.