A database, PROPERTY, was set up to show the prices of properties for sale and the features of each property. Part of the database is shown below. Property Type Brochure No Number of Bedrooms Number of Bathrooms Garden Garage Price in $ Bungalow B17 7 4 Yes Yes 750,000 Apartment A09 2 1 No No 100,000 House H10 4 2 Yes No 450,000 House H13 3 2 Yes No 399,000 Apartment A01 2 2 No Yes 95,000 Apartment A16 1 1 No No 150,000 House H23 3 1 No Yes 250,000 House H46 2 1 Yes Yes 175,000

1. (a)Give the number of fields that 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. Garage Number of Bedrooms Price in $[3]
4. (d)The query-by-example grid below selects all houses with more than 1 bathroom and more than 2 bedrooms. Field: Property Type Number of Bedrooms Number of Bathrooms Price in $ Brochure No Table: PROPERTY PROPERTY PROPERTY PROPERTY PROPERTY Sort: Ascending Show: ☐ ☐ ☒ ☒ Criteria: = 'House' >2 >1 or: Show what would be output.[2]
5. (e)Complete the query-by-example grid below to select and show the brochure number, property type and price of all properties with a garage below $200,000. Field: Table: Sort: Show: Criteria: or: [4]