THIS IS THE SCENARIO I HAVE PUT WHAT I HAVE DONE AT THE BOTTOM IN 3RD NORMAL FORM BUT IT JUST DONT SEEM RIGHT! PLEASE CAN SOMEONE TRY FIX DIS PROBLEM AND TELL ME IF THIS IS CORRECT IF NOT THE CORRECT WAY!

Hamiltons Vets is a medium sized veterinary surgeon based in north east London founded and run by Stephanie Hamilton. Stephanie wants a database system developed to handle the records of patients, prescriptions and referrals. Although Hamiltons had traditionally dealt with dogs and cats they also have to treat more exotic species especially as these become more popular as pets; to this end they have employed Dave Nellis a vet from Australia who specialises in snakes and lizards. Hamiltons requirements are for a system that keeps records of their patients, patient’s owners and the type of animal they are. For appointments they need to know with which vet the appointment is with as well as the time and date. The outcome of the appointment might be a prescription with one or more drugs on it. Repeat prescriptions are seen as being the outcome of a single appointment. An appointment might also lead to a referral or number of referrals for a particular treatment. Hamiltons referrals are for treatments carried out at only one particular treatment centre each.



Materials.

1. Interview with Stephanie Hamilton
‘Things have been expanding in recent years. That’s why we’ve taken on Dave. So now we have myself, Dave, Adrian Cooper, Suleman Faizi and Emma Goldman. The real substance of our work is the appointment where people bring in their pets. Owners who have more than one pet tend to use us for all of them. We charge for each appointment and for each prescription made out depending on the cost of the drug. Any treatment carried out by treatment centre is billed by them and has nothing to do with us.
‘One other thing. If you examine our manual records they might not seem very precise. We don’t always seem to keep the same information for example about the owners or the types of animal. Maybe you can help us to make this more efficient’



2. Manual patient record


Name Owner Type of Animal
Tiddles Mrs Jones of 12 Armpit Road Cat
Ralph Dave Green 0902 88881 Border Collie
Allan Mrs Jones 12 Armpit Road N15 Dog
Lucy Julie Smith 0789 00021 Siamese Cat
Leccy Beggsy (Friend of Dave Nellist) Monitor Lizard



3. Example of a manual appointment record


Hamiltons Vets
23 Mare Street
E5 2YT

Name: Tiddles
Owner: Mrs Jones
Appointment Date: 01/Jan/01 2.00pm

Details:
I examined tiddles (cat) and found he had a severe in-growing toenail. Prescribed some diazipan to get him through it. Mrs Jones is bearing up.

Stephanie.

Cost of appointment £10
Cost of drugs £5
Recommend also laser treatment at Harris’s Animal Hospital Middlesex. (3 sessions)
Recommend series of training sessions at Woodhouse.

Total Cost
£15



4. Hospitals and Treatments
Treatment Type Hospital or Centre Name
Laser removal Harris’s Animal Hospital Middlesex
Extensive surgery Harris’s Animal Hospital Middlesex
Behaviour Assessment The Woodhouse Institute
Specialist Training The Woodhouse Institute

5. Example of a prescription sheet.
Prescription

PRESCRIPTION NUMBER: 0023
PATIENT NAME: Rolph
PATIENT TYPE: Alsatian Dog
OWNER: Dave Stewart
CUSTOMER ADDRESS: 11 Victoria Street, N1
PRESCRIPTION BY: Adrian Cooper (Vet)



Drug Dosage Period Length of Course Cost
Zoratin 1ml 4 hours 2 weeks 2.00
Pheno Barbatine 2 ml 6 hours 1 week 10.00
Aspirin 1ml 4 hours 2 days 0.50


Patient Number
Patient Name
Owner Name
Owner Address
Owner telephone
Type of animal
Appointment Number

Appointment Number
Appointment Date
Appointment Time
Appointment Details

Patient Number
Vet
Appointment Cost
Total Cost
Prescription Number

Prescription Number
Drug
Dosage
Period
Length of course
Cost

Patient Number
Treatment Type
Hospital Name
Treatment Sessions

3rd Normal Form Can Anyone Help??