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.
@0equalsTo14 ай бұрын
Hello, Carts me product id and product varient id kyon.??? Carts can have multiple items. how to handle this?
@Rohit_Rai9016 ай бұрын
Sir please make end to end E-commerce in React JS🔥💪
@sharafhusain6454 ай бұрын
👍 thanks
@w3bpiyush_6 ай бұрын
sir make a project where we can learn seo, large user database scaling, best practices tips etc
@hemaldon4 ай бұрын
Thank you
@AmanKumarSinhaOfficial4 ай бұрын
❤❤❤
@amandixit83425 ай бұрын
please make also ola/uber db design video it will be helpful
@KuldeepSingh882685 ай бұрын
Source code ha kaya bhai😊
@adeelakhanum46295 ай бұрын
database for any rental website?
@janhvi09942 ай бұрын
iska ER diagram mil sakta hai kya Sir please?
@amandixit83425 ай бұрын
apne rating reviews ka nhi attribute nhi add kiya
@KuldeepSingh882685 ай бұрын
Source code
@rajansharma5096 ай бұрын
31:38 par aapne mentation Kiya 😅hai sir ye second but good video
@rajansharma5096 ай бұрын
Cart me quantity kaha gaya sir ji 24.03
@codingkalakar6 ай бұрын
Yes, I used to forgot mentioning the required doc link in the description. By your comment I realized, so added it now.
@softboxmelody4 ай бұрын
Hello bro Need help for db design for products and attributes
@rajansharma5094 ай бұрын
@@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