1) A video hire shop uses a database to store details of the films it hires.
Below is a part of the database.
 
 

The word Horrer should be spelt Horror.

Put three of the following steps in the best order to correct the mistake.

A. Print the whole database.
B. Save the changes.
C. Correct the mistake.
D. Delete the mistake.
E. Select the Friday 13th record.

B) Which other two pieces of information in the database are probably mistakes.

C) Write down a procedure to produce a list of all the comedy films with a U rating.

D) Design a suitable coding structure for the film category field.

E) Why would the following database structure not find all of the records for comedy and adventure?

Find Film Category is Comedy AND Film Category is Adventure.

2) Often information is typed into a database by a first data entry clerk.
The same information is typed in by a second data entry clerk. If both type in the same things the computer assumes that no spelling mistakes or other errors have occured. This is known as double entry verification.

Explain one advantage and one disadvantage of this process.