add share buttonsSoftshare button powered by web designing, website development company in India

Five Key Steps to Quality Data Modelling

Many business people consider data modeling to be a black art practiced by the enterprise IT department that brings no tangible business benefits and is solely designed to make mere mortals feel confused and inferior.

Sadly, many IT departments actually foster this view and, for those that do, the data modeling that they carry out fails to deliver any real benefits – in spite of the mumbo jumbo they chant about it. You can also check this out to find more about data modeling.


                                                                           Image Source: Google

When done properly, data modeling can deliver enormous business benefits to any enterprise, which include

1.Higher quality information for all business activities

2.Easier access to that information

3.Robust information systems

4.Better identification of products, profit, and cost centers

5.Elimination of redundant and unneeded information

6.Reduced costs and increased revenues

The basic five key steps  for quality data modeling are 

Step 1 -Work through your data sources looking for and underlining all "noun structures", as these are "candidate" entities.

Step 2 – Extract all of these candidate entities, and the associations between them, into a separate document.

Step 3 – Convert these candidate entities and associations to actual entities, attributes, and relationships.

Step 4 – Build an Entity Relationship Diagram (ERD).

Step 5 – Design any required relational databases from the ERD.