DATABASE EXERCISE 9
TASK ONE
Create a file containing the information relating to your credit customers given below.
Suitable fields would be eg. customer ref, name, address, credit limit and balance.
Cust Ref | Name and address limit | Credit limit | Balance |
1 | Afton Tyres, 24 Hill St, Glasgow | 5000 | 2000 |
2 | Afton Tyres, 2 Hunter Rd, Glasgow | 7000 | 7000 |
3 | Acreshocks, 19 Green St, Paisley | 6000 | 4000 |
4 | Zippy Exhausts, 24 Craelon, Glasgow | 2000 | 1900 |
5 | Afton Radials Ltd, 5 Mill Park, Glasgow | 8000 | 1000 |
6 | Sparky Ltd, Mayloan Ind. Est., Paisley | 10000 | 9000 |
7 | Afton Tyres, 29 Greenacre Rd, Paisley | 12000 | 600 |
8 | Wheelies, 20 Marlborough Drive, Glasgow | 5000 | 100 |
10 | Speedway Capers, 18 Main St, Glasgow | 3000 | 400 |
11 | Afton Tyres, 42 Haven Ave, Paisley | 8000 | 2000 |
12 | (Enter your name here) |
TASK TWO
Using the file on credit customers which you have created, carry out the following operations:
(a) List and print out the customers in alphabetical order
(b) List and print out those customers who owe more than £2000
(c) Add the following new customers
Customer ref | Name and Address | Credit Limit | Balance |
12 | Exhausts Ltd, 29 High St, Greenock | 3000 | Nil |
13 | Cool Tyres, 23 Mains Terrace, Greenock | 200 | 400 |
14 | Basic-parts Ltd, 14 Park St,Glasgow | 5000 | Nil |
15 | Car Spares Ltd, 19 Main Terrace,Gourock | 6000 | 1500 |
(d) List and print out the data sorted in debt order.
(e) Cool Tyres, Greenock would like 100 shock absorbers at £25 each. Would you sanction this order?
Yes/No
(f) The following customers have been declared bankrupt. Delete this record from the file
Afton Radials, 5 Mill Park, Glasgow
(g) Who are our credit customers in Paisley? List these in alphabetical order and obtain a printout.
(h) Check to see if the following orders could be sanctioned and if so alter the records accordingly.
Wheelies, 20 Marlborough Drive, Glasgow
20 KXB exhausts @ £40 each Yes/No
Sparky Ltd, Mayloan Industrial estate, Paisley
100 spark plugs LL4 @ £1.50 each Yes/No
Speedway Capers, 18 Main St, Glasgow
10 super K20 exhausts @ £50 each Yes/No
Zippy Exhausts, 24 Craelon, Glasgow
20 tyres X40 @ £35 each Yes/No
(i) Acreshocks Paisley have been a good customer for 5 years. It has been agreed that their credit limit be extended to £12000. Make the necessary alterations to the records.
(j) List Glasgow customers in balance due order and obtain a printout.
(k) The following amounts have been received by the company. Alter your credit records accordingly:
Zippy Exhausts 1500
Acreshocks 3600
Afton Tyres (2 Hunter Rd, Glasgow) 6500
(l) List customers in alphabetical order, sorted on balance due and obtain a printout.
(m) The maximum amount of credit extended to customers is £12000 per barn. List, in alphabetical order, all customers who have a credit limit of £12000 and obtain a printout.
(n) Find out and write down how many customers the company has in Greenock?
(o) List the names of those customers who owe less than £500 and obtain a printout.
_________________________________________________________________