A database, MARKS, was set up to record the test results for a class of students. Part of the database is shown below. [Table 6.1] Student Name | Class ID | Maths | English | Science | History | Geography -------------|----------|-------|---------|---------|---------|---------- Paul Smith | 0017 | 70 | 55 | 65 | 62 | 59 Ravi Gupta | 0009 | 29 | 34 | 38 | 41 | 44 Chin Hwee | 0010 | 43 | 47 | 50 | 45 | 52 John Jones | 0013 | 37 | 67 | 21 | 28 | 35 Diana Abur | 0001 | 92 | 88 | 95 | 89 | 78 Rosanna King | 0016 | 21 | 13 | 11 | 27 | 15

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)The query-by-example grid below selects all students with more than 60 marks in History or more than 60 marks in Geography. Field: Student Name, History, Geography. Table: MARKS, MARKS, MARKS. Sort: Ascending. Show: [checkbox selected for Student Name], [blank checkbox], [blank checkbox]. Criteria: , >60. or: , , >60. Show what would be output.[2]
4. (d)Complete the query-by-example grid below to select and show the student names only of all students with less than 40 marks in both Maths and English. Field: , Table: , Sort: , Show: [blank checkboxes], Criteria: , or:[3]

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.