A shop that sells cheese has set up a new database table called CheeseStock to store details of the cheeses available for sale. Part of this table is given. | ChNo | Name | InStock | SupplierCode | PricePerKg | WeightKg | | :--- | :--- | :--- | :--- | :--- | :--- | | CH01 | American | Yes | XYZ | 4.50 | 20.0 | | CH02 | Brie | Yes | XYZ | 7.50 | 21.0 | | CH03 | Burrata | No | IMP | 13.75 | 0.0 | | CH04 | Camembert | No | ABC | 16.85 | 0.0 | | CH05 | Cheddar | Yes | ABC | 5.00 | 50.0 | | CH06 | Comté | No | SPC | 7.35 | 0.0 | | CH07 | Cottage | Yes | XYZ | 4.50 | 3.0 | | CH08 | Cream | Yes | XYZ | 5.50 | 6.5 | | CH12 | Emmental | Yes | IMP | 2.75 | 1.5 | | CH15 | Feta | Yes | IMP | 12.75 | 12.0 | | CH16 | Fontina | Yes | SPC | 15.99 | 1.2 | | CH17 | Gorgonzola | Yes | SPC | 15.25 | 0.3 | | CH19 | Gouda | Yes | SPC | 7.99 | 2.5 | | CH21 | Gruyère | No | SPC | 16.75 | 0.0 | | CH22 | Halloumi | Yes | IMP | 4.75 | 15.0 | | CH23 | Havarti | No | SPC | 6.75 | 0.0 | | CH27 | Manchego | No | IMP | 13.99 | 0.0 | | CH30 | Manouri | No | IMP | 18.50 | 0.0 | | CH31 | Mascarpone | No | SPC | 12.99 | 0.0 | (a) State the number of records in this part of the database table. \_\_\_\_ [1] (b) (i) Give the name of the field that would be used for the primary key. \_\_\_\_ [1] (ii) State the reason for choosing this field for the primary key. \_\_\_\_ \_\_\_\_ [1] (c) Write the output from this structured query language (SQL) statement. ``` SELECT ChNo, WeightKg FROM CheeseStock WHERE SupplierCode = 'ABC'; ``` (d) (i) Complete this SQL statement to display only the name of all the cheeses that are out of stock. SELECT \_\_\_\_ FROM \_\_\_\_ WHERE \_\_\_\_ (ii) Explain how one of the lines in your statement in part (d)(i) could be changed to display the same information.

2024 - O/N - 0478/21 | Q10

0/11

0 correct · 0 wrong

A shop that sells cheese has set up a new database table ...