Quelpr

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

Identify the field name from the Instructor table that would be MOST suitable as a primary key.

The mark scheme is shown once you've answered.

Practise this question

Other parts of this question

  1. 7(a)Identify the field that could be used as a primary key, and state ONE reason why it may NOT be a suitable primary key.[2 marks]
  2. 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]
  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