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.