Computing

The record above is from a Ferry Company database. Look at the database and answer the questions below:

1. How would the ferry company arrange the records in order of name and, where two customers have the same name, in order of departure port?
(3 marks)

2. The ferry company manager wants to print out a list of all sailings to Stornoway during the month of July. Describe how he would do this.
(4 marks)

3. The ferry company database contains customer data. Which act of Parliament must they follow to ensure customer data is kept safe?
(1 Mark)

4. List 3 things the ferry company must do to comply with this act of parliament.
(3 Marks)

The record above is from a Ferry Company database. Look at the database and answer the questions below:

1. How would the ferry company arrange the records in order of name and, where two customers have the same name, in order of departure port?
(3 marks)

2. The ferry company manager wants to print out a list of all sailings to Stornoway during the month of July. Describe how he would do this.
(4 marks)

3. The ferry company database contains customer data. Which act of Parliament must they follow to ensure customer data is kept safe?
(1 Mark)

4. List 3 things the ferry company must do to comply with this act of parliament.
(3 Marks)

Look at the database above and answer the following questions

1. State the number of fields shown above.
2. State the number of records shown above.
3. List suitable field types for all fields in the database.
4. A new patient called Elaine Johnstone joins the dental practice. What must the dentist do with the personal information Elaine Johnstone gives her?
5. Describe how the dentist can find out which patients live in the town of Lomond.

Look at the database above and answer the following questions

1. State the number of fields shown above.
2. State the number of records shown above.
3. List suitable field types for all fields in the database.
4. A new patient called Elaine Johnstone joins the dental practice. What must the dentist do with the personal information Elaine Johnstone gives her?
5. Describe how the dentist can find out which patients live in the town of Lomond.

A quick recap on the database search techniques we discussed last week….

< less than
> greater than
<= less than OR equal to
>= greater than OR equal to
<> not equal to

To carry out a range search for dates etc you could enter something like 01/07/2011..31/07/2011. This would search for appointments in the month of July.

“simple search” = Searching on one field

“complex search” = searching on two or more fields