Physical Model: It is the physical depiction of the database.Database Physical Design: It defines the file organization, internal database storage design and indexing techniques.Logical Design: In Logical design, we create all the keys, tables, rules, constraints, etc.Database Logical Design: It defines the database inside a data model of a particular database management system.Reference Table: We can resolve the many-to-many relationships among the entities into one-to-many and many-to-one relationships through a reference table.Relationship: Relationship among the entities explains how one entity is connected to another entity.Attribute: Attributes give a way of structuring and organizing the data.Example: Customers, Orders, Products, etc. Entity: Entities are the items of the business environment regarding which we need to store the data.Through the reports, data modeling helps in data analysis. Data modeling enables us to query the data of the database and obtain different reports according to the data.Data Model assists in documenting the data mapping in the ETL process.The Data Model enhances communication throughout the organization.The data model assists us in identifying proper data sources to inhabit the model.The data model is also useful for identifying redundant and missing data.įollowing are the essential advantages of Data Modelling.The data model depicts the best understanding of the business requirements.It gives a clear picture of the database, and database developers can use it for creating physical databases.The data model establishes stored procedures, relational tables, foreign and primary keys.A data model assists in designing the database at the physical, logical, and conceptual levels.Data models assure uniformity in the naming conventions, security semantics while assuring the data quality. A data model highlights the essential data and how we must arrange that data. Types of Data Modelingĭata Modelling is the process of producing a data model for the data that we want to store in the database.
If you want to enrich your career and become a professional in Data Modelling, then visit Mindmajix - a global online training platform: " Data Modelling Training" This course will help you to achieve excellence in this domain. In this article, we will study data modeling examples and types of data models.
A Data Model looks like a building plan of an architect, and it assists in building a conceptual model. The data model is a theoretical depiction of the data objects and the relationships among them. The Data Modeling process creates a data model for the data that we want to store in the database.