Need for developing a Data Model:
• A new application for OLTP(Online Transaction Processing), ODS(Operational Data Store), data warehouse and data marts.
• Rewriting data models from existing systems that may need to change reports.
• Incorrect data modeling in the existing systems.
• A data base that has no data models.

Advantages and Importance of Data Model
• The goal of a data model is to make sure that all data objects provided by the functional team are completely and accurately represented.
• Data model is detailed enough to be used by the technical team for building the physical database.
• The information contained in the data model will be used to define the significance of business, relational tables, primary and foreign keys, stored procedures, and triggers.
• Data Model can be used to communicate the business within and across businesses.

---

Data Modeling Overview       Data Modeling Tools