The table, BEVERAGES, shows the number of calories in 100 ml of a range of popular beverages. It also shows the availability of these drinks in a can, a small bottle and a large bottle. BevNo BevName Calories Can Small Bottle Large Bottle Bev01 Cola 40 Yes Yes Yes Bev02 Lime 45 Yes No Yes Bev03 Energy Drink 1 52 Yes Yes No Bev04 Energy Drink 2 43 Yes No No Bev05 Mango 47 Yes No Yes Bev06 Lemon Iced Tea 38 Yes No Yes Bev07 Lemonade 58 Yes Yes Yes Bev08 Orange Juice 46 Yes Yes No Bev12 Apple Juice 50 Yes Yes No Bev15 Chocolate Milk 83 Yes Yes No

1. (a)Give a reason for choosing BevNo as the primary key for this table.[1]
2. (b)State the number of records shown in the table BEVERAGES.[1]
3. (c)List the output that would be given by this query-by-example. Field: BevNo BevName Can Small Bottle Large Bottle Table: BEVERAGES BEVERAGES BEVERAGES BEVERAGES BEVERAGES Sort: Show: Criteria: or: Descending ✔ ✔ = "Yes" = "Yes" = "Yes" [3]
4. (d)Complete the query-by-example grid to output a list showing just the names and primary keys of all the beverages with a calorie count greater than 45. The list should be in alphabetical order of names. Field: Table: Sort: Show: Criteria: or: [4]

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.