DEV Community

Discussion on: eCommerce Database Design

Collapse
 
ezzdinatef profile image
Ezzdin Atef

Thank you so much for your positive feedback and insightful suggestions! I'm thrilled to hear that you found the article interesting.

  1. You have a good point about the product_id redundancy, and I will updated the structure with this optimization.

  2. Regarding the storage of the total directly in the cart table, I appreciate your concern about redundancy and potential data integrity issues and instead of that we can calculate the total dynamically when needed, and actually I don’t know much about the event-driven mechanism and will lock into that. Thanks Adhiraj!