Data modeling is a conceptual process, representing the associations between the data in a manner in which it caters to specific business requirements. In this process, the various data tables are linked as per the business rules to achieve business needs.
Let's understand data modeling using a real-life example. Assume that we want to understand the buying pattern of a customer in the retail industry. For this analysis, we would require the following details:
- Customer details: This detail is stored in the Customer table
- Sales transactions: This detail could be stored in multiple tables, but let's assume that this data is available in the Sales table
- Product details: This detail is available in the Product table
If we wish to find what products are bought by a customer, we need to link all the preceding tables with each other to get the...
