Make your own free website on Tripod.com

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.