Best way to design a database for a bakery store?
You have an ingredient; let's call this "strawberry mix, packet, 100g". You also have a product; let's call this "strawberry mix". There is a Product_Ingredients row which maps the product "strawberry mix" to the ingredient "strawberry mix, packet, 100g" with a quantity of 1. No need to convert anything to anything.