Conceptual, logical, and physical data models

Data models can be designed with slightly different notations, but no matter how you design them, a model that describes everything in your data project would be as complex as your database and become too big to be useful as a communication tool.

Furthermore, when working on a data engineering project, you have discussions with different people, and these discussions focus on different levels of detail with respect to the data, business, and technical aspects of the project.

It is common to refer to the following three types of data models, which differ in the level of detail:

• Conceptual data model: This is the most abstract model, defining what will be in the domain of the project, providing the general scope
• Logical data model: This model provides much greater detail, defining what the data will look like
• Physical data model: This is the most detailed model, describing exactly how the data will be stored in the database...