We are Designing Database for a project. We have
- Customer Master Table
- Item master Table
a) Item Sub Master
Each Customer will have min of 3000 Items
Each item will have min of 30 Sub Items.
i.e, For each customer we 9000 rows in the transaction table.
Suppose if we have 500 Customers 45,00,000 rows
We thought of keeping each customer data in text file (Json Format)
Kindly suggest what is this the best way to handle the transaction DB. Frequent Update will be there for the table.