General Homework Database Questions

What is your teacher's name.

Mrs Smith
Mr Munro
Mr Carey
Mr McGivern

Soames Motors is a company that sells used cars. The Company uses a database package to hold information about customers and their purchases. A sample record is shown below.

When an employee starts up the database program, they type in a password that does not appear on the screen.

Why does this password not appear on the screen? PS (1 point)

Resource 1

Why are passwords necessary? KU (2 points)

Each night the database is saved onto hard disc, and a backup copy is made on tape. Give two reasons why a backup copy should be made. KU (2 points)

The Company wishes to print a list of all customers in alphabetical order.
Describe how you could use the database to do this. PS (2 points)

The company is offering a special price on all Ford cars. They wish to write to customers who bought Ford model cars more than two years ago. On which two fields do they need to search? PS (2 points)

The display of the database has been changed as shown.

What has been done so that the database looks like the display shown? PS
(1 point)

Resource 1

The Company sometimes sells lists of customer details to other companies.

Give one advantage to Soames Motors of selling these customer lists. PS (1 point)

Give one advantage for a company that buys these customer lists. PS (1 point)

Some customers do not want to be on these customer lists. Give one reason why they may not want to be on these customer lists. PS (1 point)

Basic Operations

Advanced Topics & Practice

Helpful Extras

Homework

General Homework Questions

Database Homework 5

Name:
Email: (optional)