Quelpr
2 marksManipulating Data in a Database

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

Write a query to show ALL courses in the NS faculty with MORE than 5 credits.

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(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 Manipulating Data in a Database questions · all CSEC Information Technology past papers