I have multiple suppliers selling products but 2 different suppliers
can sell the same product, example i have supplier_id 1 and
supplier_id 2 selling the product with product_id 100 (for a different cost)
so in this scenario what could be my primary key and what should be the
Do i relly need a primary key in the first place? or can i just use composite keys in this scenario?