What is Database Modeling? Benefits of Database Modeling | Phases of Database Modeling

Welcome back MechanicaLEi, did you know that data modeling helps to visualize the representation of data and enforce various rules on that data? This makes us wonder, What is Database Modeling? Before we jump in check out the previous part of this series to learn about What Data Independence is? Now, Data modeling as the name suggests is the process of creating a data model for the data to be stored in a Database. It is a conceptual representation of Data objects, the associations between different data objects, and their rules. It offers the following benefits: First, Data modeling allows you to normalize your data and to define it in terms of what it is and what attributes it can possess. Data Modelling also provides the tools to query the database and derive reports from it. Second, By modeling the data in each system, you can see relationships, redundancies, resolve discrepancies, and integrate disparate systems so they can work together. Third and last, Data modeling helps make better decisions about data warehousing and repositories.
There are three phases in Database Modelling: First, comes the Conceptual design phase. Here, a high leveled conceptual data model is used wherein the basic data modeling operations can be deployed to define the high-level user operations. Second, comes the logical design phase. This phase gives us a result of relation schemas and removes superfluity using normalization. Third and last is the Physical design phase. In this phase, we implement the database design. Here, a DBMS must be chosen and SQL clauses are written to help in creating the database. Also, the indexes and integrity constraints are defined. After all this, the data is added and the database can finally be tested. Hence, we first saw what Data modeling and its benefits are and then went on to see what different phases of data modeling are?
In the next episode of MechanicaLEi find out What an Entity-relationship model is?

Attributions:

[MechanicalEI]

Hey MechanicaLEi,
Check out this video of what Data modeling is, then see what its benefits and phases are and then tell us what you think.