Quelpr
2 marksDatabase Terminology

CSEC Information Technology · May/June 2019 · Paper 2 · Question 7(a)

A spreadsheet containing learner-driver records from a database table.

Identify the field that could be used as a primary key, and state ONE reason why it may NOT be a suitable primary key.

This question uses a figure or table from the paper — you'll see it when you practise.

The mark scheme is shown once you've answered.

Practise this question

Other parts of this question

  1. 7(b)(i)Complete the table to show two field names and their data types that could be used in an Instructor table.[2 marks]
  2. 7(b)(ii)Identify the field name from the Instructor table that would be MOST suitable as a primary key.[1 mark]
  3. 7(c)Write the results of a query that lists the learner drivers assigned to Rick.[2 marks]

More practice: the rest of this paper · more Database Terminology questions · all CSEC Information Technology past papers