| 1. |
The following
is a sample of a computerised database: |
(1) |
| |
|
|
| |
Surname
|
Forename |
House |
Year |
| Smith |
Joe |
X |
1 |
| Burns |
Joseph |
C |
2 |
| Curran |
Aidan |
O |
1 |
Taylor
|
Alan |
X |
1 |
| Davis |
Joanne |
O |
2 |
| Thomson |
Mary |
X |
2 |
| Houten |
Anne |
X |
2 |
| McCann |
Anna |
C |
2 |
| Smith |
Ann |
L |
1 |
| Smyth |
Ann |
O |
1 |
| McCain |
Alan |
L |
1 |
| Thompson |
James |
C |
2 |
|
|
| |
|
|
| 1. |
How many records
would be found when the following queries were performed? |
|
| |
|
|
| |
(a) surname=Smith |
(1) |
| |
|
|
| |
(b) forename=Ann |
(1) |
| |
|
|
| |
(c) House=
X OR C |
(1) |
| |
|
|
| |
(d) Year <3
|
(1) |
| |
|
|
| |
(e) Year >
1 |
(1) |
| |
|
|
| |
(f) House
NOT L |
(1) |
| |
|
|
| |
(g) Forename
= Ann AND House = L |
(1) |
| |
|
|
| 2. |
Write criterion
to find the following: |
|
| |
|
|
| |
(a) All pupils
in Campion house |
(1) |
| |
|
|
| |
(b) All pupils
in S1 |
(1) |
| |
|
|
| |
(c) Anyone
called Joseph or Joe |
(1) |
| |
|
|
| |
Total |
(10) |
