Computer Science · May / June 2020 · Paper 22 · Question 6

A database table, JUICE, is used to keep a record of cartons of fresh fruit juice available for sale. Juice code Fruit 1 Fruit 2 Size Volume (ml) Stock level LMO10 Mango Orange Large 1000 18 MOO05 Orange Orange Medium 500 8 SAM02 Apple Mango Small 200 25 SAA02 Apple Apple Small 200 50 SPP02 Pineapple Pineapple Small 200 10 MMM05 Mango Mango Medium 500 12 LMM10 Mango Mango Large 1000 5 MGG05 Guava Guava Medium 500 5 SMO02 Mango Orange Small 200 7 MOP05 Orange Pineapple Medium 500 12 LAA10 Apple Apple Large 1000 32 SGO02 Guava Orange Small 200 10 LPP10 Pineapple Pineapple Large 1000 3 LOO10 Orange Orange Large 1000 25 SOO02 Orange Orange Small 200 40

Read automatically from the paper; the printed page above is exact.