Quelpr
1 markDatabase Terminology

CSEC Information Technology · January 2014 · Paper 2 · Question 8(a)

The Softball Association uses a database table named Member to store details of members of the association.

State the name of the table used to store data in the database.

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)Which field in the table can be used as the primary key?[1 mark]
  2. 8(c)If the records in the table are sorted from the newest to the oldest member, what will be the Membership_No. of the member who would be at the TOP of the…[1 mark]
  3. 8(d)(i)How many fields will be displayed when the query shown in the grid is executed?[1 mark]
  4. 8(d)(ii)How many records will be displayed when the query shown in the grid is executed?[1 mark]
  5. 8(e)A report is generated from the database table. State TWO fields which could be used to group the data.[2 marks]

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