DATABASE EXERCISE 1
1. Power up the system and load a database program.
2. Set up a file and give it an appropriate name. Set up fields within this file using the following headings, or suitable abbreviations.
FIELD TITLE KEY
AREA
TYPE
BEDROOMS
GARAGE Y or N
EXTRAS CH Central Heating
EH Electrical Heating
CA Carpets
LF Light Fittings
CU Curtains
PRICE
Make sure that you enter the appropriate code for the GARAGE and EXTRAS.
3. Enter the following data for the eighteen records as follows:
AREA | TYPE | BEDRMS | GARAGE | EXTRAS | PRICE |
ALLESTREE | DETACHED | 4 | YES | C HEAT | 71500 |
THULSTON | COTTAGE | 1 | YES | CARPETS | 25950 |
CHADDESDEN | BUNGALOW | 3 | YES | CARPETS | 42950 |
ALVASTON | TERRACED | 2 | NO | CARPETS | 22950 |
REDBY | SEMI-DET | 3 | NO | C HEAT | 34950 |
MICKLEOVER | DET | 3 | YES | C HEAT | 48750 |
BREADSALL | TERRACED | 1 | YES | CARPETS | 25400 |
ALLESTREE | SEMI-DET | 3 | NO | CURTAINS | 37500 |
REDBY | SEMI-DET | 3 | NO | CARPETS | 22950 |
ALVASTON | SEMI-DETD | 3 | NO | LIGHTS | 29950 |
REDBY | TERRACED | 2 | NO | CARPETS | 24500 |
ASTON | BUNGALOW | 2 | YES | C HEAT | 39950 |
ETWALL | SEMI-DET | 5 | YES | CURTAINS | 49750 |
MICKLEOVER | SEMI-DET | 3 | NO | C HEATING | 30950 |
SINFIN | TERRACED | 3 | YES | C HEATING | 27995 |
REDBY | DETACHED | 5 | YES | C HEATING | 69950 |
ALLENTON | SEMI-DETD | 3 | NO | ELEC HEAT | 31250 |
OCKBROOK | DETACHED | 4 | YES | CARPETS | 54550 |
Make sure that you have entered the appropriate code for the GARAGE and EXTRAS.
4. Add your name and date as a header, save as DATA01A and print all records in the file.
5. The house at ETWALL has been on the books for some time so the price is now reduced by £1000. Amend the record.
6. Add the following two record.
ALVASTON BUNGALOW 2 YES CARPETS 29975
OAKWOOD TERRACED 2 NO CURTAINS 29500
7. All the properties in ALLESTREE had been sold. Delete these records.
8. Sort the records alphabetically by area.
9. Print out the complete file.
10. Find all the properties which cost more than £45,000. Print out these records.
11. A prospective buyer is interested in houses which have 3 or more bedrooms and central heating. Find all the suitable properties and print out the AREA and PRICE only.
12. Close down the system.