| Things
To Do (page 288) |
|
1(a)
|
|
Wordprocessor
to send out reminders and a database to hold patient records.
|
|
(b)
|
|
Database
could provide lists of patients who need a check-up and these
could be imported into the wordprocessor to produce a mail merged
letter. |
|
(c)
|
|
Advantages:
Cheaper. Tried and tested by many users for bugs. Documentation
is often better. Disadvantage: You have to fit you system around
the progam so you don't always get the ideal system. |
|
(d)
|
|
Nurses:
Treatment is recorded. Dentists: Able to run the practice more
profitably. Patients: Less time spent filling forms in. |
|
(e)
|
|
Total
reliance on the system could cause problems if the system broke
down. |
|
|
|
|
|
2(a)
|
|
Price,
No of bedrooms, council tax banding, room sizes etc. |
|
(b)
|
|
Coded
data takes up less space on disks when stored and takes less
time to type in initially and then when typing search conditions. |
|
(c)
|
|
Hard
disk. This provides faster access so the people don't need to
wait as long. |
|
(d)
|
(i)
(ii) |
Faster location of fields when searching.
More wasted space. |
|
(e)
|
|
Need
a WAN with a larger computer connected via modems and telecommunication
lines to the branches. Each branch should have a PC which has
a laser printer for printouts for the customers. |
|
|
|
|
|
3(a)
|
|
List
Description, FOR Current_stock-level more than 100 and Lead_time
less than 14 |
|
(b)
|
|
A
duplicate copy of the data should be made periodically under
a different file name and a tape streamer should be used to
backup the entire hard disk every evening. Backup copies should
be stored away from the computer in a fireproof safe. |
|
(c)
|
|
Use
tapes and a tape streamer to take archive copies which are stored
in a fireproof safe. |
|
(d)
|
(i)
(ii)
(iii) |
Supplier file
Supplier details such as; name, address, credit limit, amount
owed etc.
Field name Field type Size Supp_name character 40 Supp_add character
60 Post_code character 10 Tel_no character |
|
(e)
|
|
Each
week the stock file is used with the supplier file to produce
a list of orders to be sent to each supplier for goods which
have fallen below the minimum_stock level. The reorder quantity
is obtained from the stock file and the suppliers details are
obtained from the suppliers file. |
|
|
|
|
|
|
|
List
all for film_category = 'Adventure' AND Rating = 18 AND Cost
< 2.00 |
|
4(a)
|
|
Membership
number, date of birth, phone number and members name. |
|
(b)
|
|
Any
suitable form. |
|
|
|
|
|
5(a)
|
|
Form
should include sensible details such as price, make, model,
engine size, year etc. The general layout of the form is important
and the form should contain a suitable amount of space for the
seller to insert the information. |
|
(b)
|
|
Need
a sensible sort and search command (could be in either order).
(n.b. there needs to be some way of ensuring that the vehicle
is under 5 years old). Could do this either from the year or
not as accurately, from the registration number. |
|
(c)
|
|
He would probably be able to keep the details in his head or
in a card index file for such a small number of cars. |
