This article gives an overview of Data Modeling in Software Applications. It describes commonly used terms and explains the step by step process using a sample Retail Sales Case Study.
Published in · 6 min read · May 23, 2020
--
If you look at any software application in the world, you will see that at the very fundamental level, it will deal with organization, manipulation and presentation of data to fulfill the business requirements.
A data model is a conceptual representation to express and communicate business requirements. It visually represents the nature of data, business rules governing the data, and how the data will be organized in the database.
The process of data modeling can be compared to the process of construction of a house. Assume that a company ABC needs to build a guest house (data base). It calls a building architect (data modeler) and explains its building requirements (business requirements). Building Architect (data modeler) develops the plan (data model) and gives it to company ABC. Finally company ABC calls civil engineers (DBAs and database developers) to construct the guest house (database)