Databases

Questions

These are GCSE questions, mostly in their original form, with the number of marks as shown on the paper:

A family is planning a last minute summer holiday. They use the Internet to find details of holidays that are still available leaving on Saturday 2nd July or Sunday 3rd July from Manchester. The result of the search from one travel company’s website is shown in the database table below.

1.	What is meant by the term field?	(1 mark)

2.	How many fields are shown in each record in this database table?		(1 mark)
	Number of fields

3.	Which is the key field in this database table	(1 mark)
	Key field

4.	State why a key field is needed in a database table.	(1 mark)

5.	The result of the search shown in the database table above has been sorted into order. Describe the order into which the table has been sorted.	(3 marks)

A health club stores information about its members in a database table. Part of the database table is shown below.

6.	How many records are shown in this database table?	(1 mark)
	Number of records

7.	Why would the Last Name field not be suitable to use as the key field?	(1 mark)

The data entered into the Member Type field has been coded as follows:

JoP– Junior off Peak JP– Junior Peak SoP– Senior off Peak SP– Senior Peak

Give one advantage of coding data.

(1 mark)

9.	When the database was set up, the House Number field was formatted as a text field. Explain why this is a suitable format in the table given.	(1 mark)

Your name: Your e-mail address: