Quelpr
2 marksCreating and Modifying a Database

CSEC Information Technology · 2011 · Paper 2 · Question 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 $250, write the formula for the calculated field.

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