You own a fruit shop. You buy fruit from suppliers by weight (cost per kg), and then you sell it either loose or pre-packaged for a fixed price. For example, a typical sale could be:
1. Apples Pink Lady 1.360kg x $3.50/kg = $4.76
2. Pears Golden 3.400kg x $1.75/kg = $5.95
3. Apples Green Smith 2.180kg x $2.50/kg = $5.45
4. Breakfast package 2x $5/pk = $10
5. Mandarins package 1x $3/pk = $3
-- Total $29.16
Where "Breakfast package" might consist of:
a. Bananas Cavandish 500g
b. Apples Green Smith 500g
c. Mandarin Imperial 500g
And "Mandarins package" is:
a. Mandarins Imperial 600g
b. Mandarins Queens 400g
Question
-----------
How can I create a relational database schema to record stock and sales?
MYSQL