I
interlekt
Guest
This is my scenario and i have put my answer in 3rd normal form at the bottom (in red) but i know it doesnt seem right, Can anyone help?? just tell me the answer in 3rd normal form which is correct because this is doing my head in 
Goddards Vets is a medium sized veterinary surgeon based in north east London founded and run by Stephanie Goddard. Stephanie wants a database system developed to handle the records of patients, prescriptions and referrals. Although Goddards 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. Goddards requirements are for a system that keeps records of their patients, patient’s owners, 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. Goddards referrals are for treatments carried out at only one particular treatment centre each.
Materials.
1. Interview with Stephanie Goddard
‘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 appointments 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. It would be really nice if I could have a report that gave me a summary of the total cost of a patient’s appointments and the prescriptions which could then be sent to the owner. 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
Goddards 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
Asparin 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
Hospital Name
Treatment Sessions
Treatment type
Goddards Vets is a medium sized veterinary surgeon based in north east London founded and run by Stephanie Goddard. Stephanie wants a database system developed to handle the records of patients, prescriptions and referrals. Although Goddards 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. Goddards requirements are for a system that keeps records of their patients, patient’s owners, 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. Goddards referrals are for treatments carried out at only one particular treatment centre each.
Materials.
1. Interview with Stephanie Goddard
‘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 appointments 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. It would be really nice if I could have a report that gave me a summary of the total cost of a patient’s appointments and the prescriptions which could then be sent to the owner. 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
Goddards 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
Asparin 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
Hospital Name
Treatment Sessions
Treatment type