DATABASE EXERCISE 5

 

SCENARIO

You are in the USA working for a wholesale distributor in the clothing trade. You have been asked to set up an electronic database system containing details of your retail customers, including their address and credit limits. You will carry out the following steps to do this. You are also asked to supply certain reports and answer queries on the data in the system, which you also do.

1. Power on your equipment and log-on.

2. Create a file of customers' details with 50 records and five fields.

3. Enter the following five fieldnames.

NAME

CITY

STATE

ACCNO

CREDLIM

4. Enter the following data under the correct field names.
NAME CITY STATE ACCNO CREDLIM
Amanda Baltimore Maryland 081 1350
Bilson New York New York 234 1300
Braemar Fashions Denver Colorado 597 2000
Brown & Johnson Cleveland Ohio 767 1300
Carrington B Denver Colorado 991 4500
E & M Fashion House Atlanta Georgia 489 1000
Ewing J R Dallas Texas 023 2450
Garden Centre Baltimore Maryland 200 2000
Hilto J Atlanta Georgia 100 2000
Kenworthy N Cincinnatti Ohio 150 2500
King S & A Houston Texas 501 1600
Macdonald Ltd Houston Texas 333 2250
Marbren Ltd Columbus Ohio 400 2500
M & E Modes Dallas Texas 222 2250
Peters J Cincinnatti Ohio 123 1000
Russell Derek & Son Baltimore Maryland 664 1000
Sadler T Columbus Ohio 220 2500
Smith T & Son Chicago Illinois 305 2750
Yates C & Son Cleveland Ohio 427 3000
Wilson Houston Texas 101 2100

5. When you have finished entering the data then produce a print-out of the names on the printer:

6. Prepare and display on the screen a list of names with a credit limit of $1500 or more.

7. Prepare and display on the screen a list of names with a credit limit of $2000 or less. Write down the total number of entries on the list.

8. Prepare and display on the screen a list of names in the state of Ohio. Write down the total number of entries on the list.

9. Prepare and display on the screen a list of names in the state of Texas. Write down the total number of entries on the list.

10. Save your datafile.

11. Prepare and display on screen a list of names in the city of Cleveland. Write down the total number of entries on the list.

12. Sort the file, prepare and display a list of names and account numbers in ascending order of account number.

13. Sort the file, prepare and display a list of names and account numbers in alphabetical order of state. Write down the total number of entries on the list.

14. Add the following record to the file:

Glover J & Son, Columbus, Ohio, Acc No. 420, Credit limit $4000

15. Prepare and display on screen a list of customers in Ohio who have a credit limit of between $2000 and $3000. Write down the total list of entries on the list.

16. Delete your file and close down the system.