DATABASE EXERCISE 8
1. Power up the system and select an empty user area.
2. Load a database package and set up a file to contain information from a questionnaire produced by pupils in a school. Use the following field titles, which can be abbreviated if necessary.
SURNAME
FORM
SEX
BIRTHPLACE
HOBBY
WEIGHT (KG)
EYE COLOUR
Use the following code letters:
In the SEX field:
M Male
F Female
in the EYE COLOUR field:
BL for BLUE eyes
BR for BROWN eyes
GR for GREEN eyes
1. Enter the following details:
SURNAME | SEX | BIRTHPLACE | HOBBY | WEIGHT | EYE COLOUR |
FORM IT
LAWSON | MALE | LONDON | SWIMMING | 43 | GREEN |
LEACH | MALE | PORTSMOUTH | SAILING | 20 | BLUE |
CROSS | FEMALE | CARDIFF | CADETS | 50 | BLUE |
SMITH | FEMALE | PORTSMOUTH | FARMING | 33 | GREEN |
WARNER | MALE | PLYMOUTH | DRAWING | 35 | BROWN |
KERBY | FEMALE | WINCHESTER | SPORT | 55 | BLUE |
FORM 1B
PROSSER | MALE | LIVERPOOL | FOOTBALL | 35 | BROWN |
BURCHELL | FEMALE | LONDON | CADETS | 35 | BLUE |
SIMMONDS | MALE | GLASGOW | FOOTBALL | 37 | GREEN |
FORM 1A
HOLLIS | FEMALE | PORTSMOUTH | GUIDES | 40 | BROWN |
SINGH | FEMALE | FARNHAM | DANCING | 41 | BLUE |
EDWARDS | FEMALE | OXFORD | BALLET | 37 | GREEN |
CUADRADO | MALE | CARLISLE | READING | 39 | GREEN |
FORM 1M
MILLER | FEMALE | CRAWLEY | DANCING | 45 | BLUE |
THOMAS | FEMALE | NORWICH | JUDO | 48 | BLUE |
WEBB | MALE | WINCHESTER | SKATING | 49 | GREEN |
O'NEILL | MALE | OXFORD | FOOTBALL | 50 | BROWN |
Make sure CODE LETTERS are used for the SEX and EYE COLOUR
4. Load the printer with paper, set to the top of the form and print out the complete file. (Your name at end of printout please)
5. Miss Thomas in 1M has left: delete her record.
6. The BIRTHPLACE of Miss Burchell, in 1B was incorrectly entered: replace LONDON with YORK.
7. The details of two BLUE EYED BOYS are to be added to the database; amend the file accordingly.
GRIFFIN 1B PORTSMOUTH TENNIS 49
FINCH 1B CARDIFF FISHING 38
8. Sort and print the complete file in alphabetical order by SURNAME. (Your name at end of printout please)
9. Search the file for all those pupils who were born in PORTSMOUTH and print out all those fields of these records. (Your name at end of printout please)
10. Find all the pupils who have BLUE EYES and are over 44KG in WEIGHT and print out the SURNAME, SEX AND HOBBY of each of these records. (Your name at end of printout please)
11. Save the data.
12. Close down the system.