Definition of Data Modelling

Data Modelling is a process of identifying the business requirements of an organization and modelling the organization of data to meet. Data modelling evaluates and measures the flow of data in and out to the database management system. It describes the treatment of data and its connecting objects. It ensures a great customer experience by modelling the business data in a most appropriate manner.

Data modelling Types

There are 3 types of Data modelling

• Conceptual
• Logical
• Physical

Conceptual Data Modelling

Conceptual modelling is a method of describing information in high level. It describes the semantics of an organization and its assertions. It usually hides the internal or low level of information about data structures.

Logical Data Modelling

Logical modelling is a representation of logical design of an information system, a representation of the abstract structure of the information domain that defines all the logical constraints applied to the data stored. 

Physical Data Modelling

Physical data modelling is a representation of an implementation design of business requirement. A complete physical schema includes artifacts required to achieve performance goals or create relationships between data, such as indexes, linking tables, and constraint definitions. Analysts can use a physical schema to calculate storage estimates, and this may include specific storage allocation details for an information system.

In a simpler way, An entity (in logical modelling) is called as Table (in physical modelling) and Attribute (in logical modelling) is called as Columns (in physical modelling).

If you enjoyed this blog post, feel free to share it with your friends!