Quelpr
3 marksCreating and Modifying a Database

CSEC Information Technology · May/June 2013 · Paper 2 · Question 8(a)

A list of customers, money owed, and phone numbers is provided: Jimmy Smith, 355.98, 654-2586 Daniel Maharaj, 564.76, 653-8652 Gemma Gordon, 456.23, 658-8693 Sarah Daniels, 35.89, 659-5781

Complete the database structure table by specifying Field Name, Data Type, and Field Description to store the given customer data.

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 a field name from the list you have provided in (a) above that can be used as a primary key.[1 mark]
  2. 8(c)Write the criteria to search the database table for all the persons who owe more than $500.00.[2 marks]
  3. 8(d)State the feature of a database management system that prints data in a specified format with a title.[1 mark]

More practice: the rest of this paper · more Creating and Modifying a Database questions · all CSEC Information Technology past papers