Quelpr
1 markGenerating Reports

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

State the field in the COURSE table that would be MOST appropriate to use to group the data when preparing a report.

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(b)State the primary key in the COURSE table.[1 mark]
  3. 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]
  4. 8(d)Write a query to show ALL courses in the NS faculty with MORE than 5 credits.[2 marks]
  5. 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]

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