General Homework Database Questions

What is your teacher's name?

Mr McGivern
Mr Munro
Mrs Smith
Mr Carey

A Mail Order Company keeps details of customer accounts on a computer using a database package. Here is part of the information held about one of the customers.

The information stored about customers is confidential. Some customers are concerned that this information could be misused. Give one step that the Company could take to ensure the information is not misused. PS (1 point)

Resource 1

Describe how the database package could be used to obtain a list of all customers in alphabetical order. PS (2 points)

The Company wishes to offer a special discount to customers who have placed an order since 1st January 1998 and who owe less than £100. How could the database be used to get a list of all customers eligible for this offer?PS (4 points)

Company staff must access customer's record immediately in case a customer phones about an order.

What type of backing storage will be used to allow this type of access? KU (1 point)

Give two reasons for your answer above. PS (2 points)

The Company used to keep the information about customers on record cards.

Give two advantages of using a database package instead of record cards. KU (2 points)

Describe two initial costs to the Company of setting up the computer system. KU (2 points)

Describe one running cost to the Company of the computer system. KU (1 point)

Suggest two changes to the working conditions of the employees since the introduction of computers. KU (2 points)

Basic Operations

Advanced Topics & Practice

Helpful Extras

Homework

General Homework Questions

Database Homework 4

Name:
Email: (optional)