Computer Science · Oct / Nov 2019 · Paper 22 · Question 7

A database table, SALES, is used to keep a record of items made and sold by a furniture maker. Item number Order number Notes Amount Status CH001 1921 Smith – six dining chairs 6 Delivered TB003 1921 Smith – large table 1 In progress CH001 1924 Hue – extra chairs 4 In progress CH003 1925 For stock 2 Cancelled BN001 1927 Patel – replacement bench 1 Not started ST002 1931 Sola – small table 1 Delivered CH003 1927 Patel – eight dining chairs with arms 8 Not started TB003 1927 Patel – large table 1 Not started

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