can anyone help me with putting this into 3rd normal form im very stuck
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.
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
23 Mare Street
Owner: Mrs Jones
Appointment Date: 01/Jan/01 2.00pm
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.
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.
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 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
Type of animal
Length of course