A garden centre sells garden tools and stores details of these in a database table named TOOLS. Code is the primary key in the TOOLS table. Code | Description | Price ($) | Quantity_Stock | Quantity_Ordered -------|-------------------------|-----------|----------------|----------------- GFLG | Garden Fork | 50.00 | 1 | 50 GSLG | Garden Spade | 50.00 | 11 | 0 GHLG | Garden Hoe | 45.00 | 8 | 0 HFSM | Hand Fork | 9.99 | 42 | 0 HSSM | Hand Spade | 9.99 | 40 | 0 HWSM | Hand Weeder | 9.99 | 11 | 0 HS20 | Hose (20 metres) | 45.00 | 10 | 0 HS35 | Hose (35 metres) | 60.00 | 2 | 0 HS50 | Hose (50 metres) | 75.00 | 20 | 60 YBLG | Yard Brush | 24.99 | 100 | 0 LMHD | Lawn Mower | 99.99 | 5 | 0 LMBT | Lawn Mower (Battery) | 249.99 | 7 | 0 LMPT | Lawn Mower (Petrol) | 349.99 | 10 | 25 TRBT | Edge Trimmer (Battery) | 79.99 | 15 | 0 TRPT | Edge Trimmer (Petrol) | 59.99 | 20 | 0 SHSM | Shears | 40.00 | 40 | 0 HCSM | Hedge Clippers | 40.00 | 45 | 0

1. (a)State the purpose of the primary key in the TOOLS table.[1]
2. (b)List the output from the data shown in the table TOOLS that would be given by this query-by-example. ``` Field: Code Description Price ($) Quantity_Stock Quantity_Ordered Table: TOOLS TOOLS TOOLS TOOLS TOOLS Sort: Descending Show: ✔ ✔ ✔ ✔ Criteria: >40 >0 >0 or: ```[3]
3. (c)Complete the query-by-example grid to output the tools where the quantity in stock is below 25. Only show the Code, Description and Quantity_Stock fields in ascending order of Code. ``` Field: Table: Sort: Show: Criteria: or: ```[3]