Name: ……………………………………………………. Date: ……………………………

Database Theory Test

A community centre has started to run a youth group for children ages between 5 and 14. A database is used to store information on the children. Part of the database file is shown below:

ID Number / Surname / Forename / Sex / Date of Birth
1001 / Jones / Amy / F / 10.11.95
1002 / Smith / Patricia / F / 13.3.93
1004 / James / John / M / 15.2.94
1005 / Walker / Anne / F / 16.6.95
1006 / Mills / Rebecca / F / 20.02.96
1008 / Mills / Peter / M / 10.3.94
  1. How many records are shown in this database file?

(1 mark)

  1. How many fields are shown in each record of this database file?

(1 mark)

  1. Name one field in which the data has been coded.

(1 mark)

  1. Give two advantages of coding data.

Advantage 1:

Advantage 2:

(2 marks)

  1. Which field is the key field in this database file?

(1 mark)

  1. Explain why the field you have named in (5) is suitable to be used as a key field.

(2 marks)

  1. Give four fields, which are not given above, that the centre may wish to hold on the youth group database.

( 2 marks)

  1. The community centre will collect information from children by giving them a form to take home for their parents to fill in. This will then be used to update the database.

Using the database layout on page one and your answers in (7), design the form for the community centre to use for the Youth Group.

Draw your form on the back of this sheet. Use a ruler and pencil for any lines – do not draw freehand.

(10 marks)

  1. For the form you have designed in (8), indicate the field names and the field length and type:

e.g. name – text field, 15 characters.

(10 marks)

  1. Explain clearly the difference between information and data. An example of the difference may be used to illustrate your answer.

(3 marks)

  1. Bethany is married with three children. She works as a secretary at a local hire company. She owns her own house and has a £40,000 mortgage from a building society. She enjoys reading and is a member of a mail order book club. She regularly uses a credit card to buy food from the supermarket. She also has a supermarket loyalty card, together with loyalty cards from various high street shops.

a)based on this information about Bethany, name the types of database which would hold information about her.

(10 marks)

b)state why companies would be interested in acquiring information about Bethany and her lifestyle, using each of the databases above to illustrate your statements.

(5 marks)

  1. Look at the database table given on the next page. From the information given answer the following questions:

a)What command would you use to find individuals with blue eyes?

(3 marks)

b)What command would you use to find individuals with brown eyes and black hair?

(3 marks)

c)In what order is the database table presented at the moment?

(2 marks)

Surname / First Name / Date of birth / Eyes / Hair
Jones / Anne / 15.112.78 / Brown / Black
Wood / Estelle / 6.7.78 / Green / Blond
Walker / Catherine / 10.10.78 / Blue / Brown
Smith / Jennifer / 13.12.79 / Brown / Black
Marsh / Susan / 8.5.89 / Green / Blond
Marsh / Peter / 9.4.98 / Blue / Blond
  1. Spot the mistake in the table above. How can input mistakes like this be avoided?

Total: 60 marks

Year 9 Database Theory TestPage 1 of 4