Hi guys, I have a last question
The question: what is the price of materials to manufacture product XXXX
This is my tables:
1. Product (product_name, product_price, BANR(PK)
2. Get (BANR(FK), RID(FK)
3. Recipe (receipe_name, r_update, RID(PK)
4. IN (basic_goods_amount, goods_measure, RID(FK), IID(FK)
5. Ingredient (ingredient_name, IID(PK)
6. Deliver(purchase_amount, purchase_measure, purchase_price)
All products have a unique recipe with a number of basic goods.
Basic goods are purchased in quantities from a supplier.
To answer the question I should choose a product and check out how much the ingredients cost and how much it needs.