Question

.how important is it to use data modeling when designing databases

Answer 1

The process of creating the data model for the data which we are planning to store in the Database is called as Data Modelling.Suppose if you are going to build a Multi storey building then before starting the construction we must need to create a architecture plan then only we can start our construction work.In the same way Data Modelling is just like creating the blue print of the data to be store and to relate the data.

Data models helps in ensuring that all the semantics,naming conventions ,default values,constraints are being followed or not.

Some of the reasons why we use Data Modelling are :

1. We can define tables,Primary and Foreign keys and relationship among different tables in the Data Model.

2. It becomes much easier for the Database Engineers to build the physical Database using the data model.

3. We can design the Data Base at the conceptual, physical and logical levels.

4. We can find out the duplicate records easily.