Computer Science · May / June 2019 · Paper 2 SL · Question 3
IBCS
As printed in the paper
The question as text
3. Armour Hardware Company has the following data about salespersons and the quantities of items sold. Each salesperson can sell many different products. SALES_PERSON Product_ Number Unit_ Price Product_ Name Date_And_ Time Sales_ Person_ Number Sales_ Person_ Name Manager_ Number Manager_ Name 19 440 12.50 Saw 03/07/2018 12:23:34 102 Owen 16 Benson 32 456 14.50 Hammer 03/07/2018 12:56:23 35 647 35.00 Drill 03/07/2018 12:35:02 199 Dahl 45 Rogers 67 895 13.25 Wrench 03/07/2018 12:49:56 98 760 12.25 Pliers 03/07/2018 13:23:34 67 896 9.25 Wrench 03/07/2018 12:46:23 154 Fraser 16 Benson 32 456 14.50 Hammer 03/07/2018 12:50:16 35 647 35.00 Drill 03/07/2018 12:55:09 234 Robert 16 Benson 32 456 14.50 Hammer 03/07/2018 12:57:12 67 895 13.25 Wrench 03/07/2018 13:25:36
Read automatically from the paper; the printed page above is exact.
Show the answer and mark scheme
3(a)[4]
3(b)[2]
3(c)[8]
3(d)[2]
3(e)[2]
Make a free account to save your answers and see your weak topics and ask the AI why a wrong answer is wrong.