Credit Homework Database Questions

CHOOSE YOUR TEACHER FROM THE OPTIONS BELOW

Mr Munro
Mrs Smith
Mr McGivern
Mr Carey

Gairfield Medical Products manufacture drugs which they supply directly to GPs.
The company has a number of sales persons in each sales area. A database stores details about each salesperson. A record containing information about one salesperson is shown:

The Total Sales field shows the total sales for a salesperson for the year. It is a computed field. Explain the term computed field. [KU] (1 point)

Resource 1

How could the database be used to find the name of the salesperson in each sales area with the highest total sales? [PS] (2 points)

The database can be read by any salesman to view their performance. However, changes can only be made by certain individuals.
Describe two features that the system would need to allow this to happen. [PS] (2 points)

The company send a list of products that they sell to GPs. The list is sent as an attachment in RTF format.
What is an attachment. [KU] (1 point)

What is meant by RTF? [KU] (1 point)

Describe one advantage of storing a file as an RTF file type. [PS] (1 point)

The company must register with the Data Protection Registrar as a data user.
As a data user, the company must prevent unauthorised access to its files.
Describe two methods to increase the security of data. [PS] (2 points)

Who are the data subjects in this instance? [PS] (1 point)

State two rights the data subjects have. [KU] (2 points)

Basic Operations

Advanced Topics & Practice

Helpful Extras

Homework

Credit Homework Questions

Database Homework 3

Name:
Email: (optional)