A database, SOFASELECT, was set up to show the prices of suites, sofas and chairs for sale from an online furniture warehouse. Part of the database is shown below. [Table: SOFASELECT database excerpt] Description | Brochure Number | Number of Seats | Number of Pieces | Material | Colour | Price in $ ------------|-----------------|-----------------|------------------|----------|--------|------------ Sofa | SF17 | 2 | 1 | Leather | Red | 950 Sofa | SF19 | 3 | 1 | Vinyl | Black | 1,000 Suite | SU10 | 4 | 3 | Velvet | Green | 1,500 Suite | SU23 | 5 | 3 | Leather | Brown | 950 Recliner chair| RC01 | 1 | 1 | Leather | Cream | 600 Chair | CH16 | 1 | 1 | Vinyl | Red | 250 Recliner sofa| RS23 | 4 | 1 | Leather | Cream | 1,200 Chair | CH10 | 1 | 1 | Velvet | Red | 175

1. (a)How many fields are in each record?[1]
2. (b)State which field you would choose for the primary key. Give a reason for choosing this field.[2]
3. (c)State the data type you would choose for each of the following fields. Number of Seats Price in $[2]
4. (d)The query-by-example grid below selects all the furniture in cream leather. Field: Description | Material | Colour | Price in $ | Brochure Number Table: SOFASELECT | SOFASELECT | SOFASELECT | SOFASELECT | SOFASELECT Sort: | | | Descending | Show: | [tick] | | | [tick] Criteria: | = 'Leather' | = 'Cream' | | or: Show the output from the query-by-example.[3]
5. (e)Complete the query-by-example grid below to select and show the brochure number, material, colour and price of all the furniture with 3 or more seats. Field: Table: Sort: Show: Criteria: or:[5]

This question uses a diagram from the original paper, which isn't shown here. Open the full paper from the past papers archive to see it.