E-commerce Application Database Design Tutorial | Coding Kalakar

[@tanzimibthesam5861]

If we see this table Product_variants Id Product_id Color (optional) Size (optional) Price (float - 10,2) Stock_quantity (integer) First of all i think its not in 2NF since color and size is dependent on product_id and not id which is primary key and stock quantity is dependant on size and color which results in transitive dependency. Ideally we can have another table for stock and product_id can be foreign key as well as primary key Also if you need to insert size and color every time it will lead to insertion anomaly . But question may come too many tables will result in too many joins and slow performance. So in this case we need to index.

[@0equalsTo1]

Hello, Carts me product id and product varient id kyon.??? Carts can have multiple items. how to handle this?

[@Rohit_Rai901]

Sir please make end to end E-commerce in React JS🔥💪

[@sharafhusain645]

👍 thanks

[@w3bpiyush_]

sir make a project where we can learn seo, large user database scaling, best practices tips etc

[@hemaldon]

Thank you

[@AmanKumarSinhaOfficial]

❤❤❤

[@amandixit8342]

please make also ola/uber db design video it will be helpful

[@KuldeepSingh88268]

Source code ha kaya bhai😊

[@adeelakhanum4629]

database for any rental website?

[@janhvi0994]

iska ER diagram mil sakta hai kya Sir please?

[@amandixit8342]

apne rating reviews ka nhi attribute nhi add kiya

[@KuldeepSingh88268]

Source code

[@rajansharma509]

31:38 par aapne mentation Kiya 😅hai sir ye second but good video

[@rajansharma509]

Cart me quantity kaha gaya sir ji 24.03

[@codingkalakar]

Yes, I used to forgot mentioning the required doc link in the description. By your comment I realized, so added it now.

[@softboxmelody]

Hello bro Need help for db design for products and attributes

[@rajansharma509]

@@softboxmelody product table me , I'd , size I'd , attributes table, I'd size , jo fields chahiye le lo aap aur join query mar Dena aap jab value lena hoga to