Quelpr
1 markDatabase Terminology

CSEC Information Technology · 2011 · Paper 2 · Question 8(b)

State the primary key in the COURSE table.

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. 8(a)What field in the COURSE table is used to sort the records?[1 mark]
  2. 8(c)The two tables have been joined by a common field. State the name of the Dean of the faculty that is offering the course with Cid = ECN 100.[1 mark]
  3. 8(d)Write a query to show ALL courses in the NS faculty with MORE than 5 credits.[2 marks]
  4. 8(e)In the COURSE table it is required to insert a calculated field named FEE to compute the fee for EACH course. If the cost per credit is…[2 marks]
  5. 8(f)State the field in the COURSE table that would be MOST appropriate to use to group the data when preparing a report.[1 mark]

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