Quelpr
1 markDatabase Terminology

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

A university uses a database with two tables to store information on courses being offered by the various faculties.

What field in the COURSE table is used to sort the records?

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(b)State the primary key in the COURSE table.[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