Quelpr
2 marksCreating and Modifying a Database

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

Complete the table to show two field names and their data types that could be used in an Instructor table.

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)(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 Creating and Modifying a Database questions · all CSEC Information Technology past papers