Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2004
    Posts
    2

    Angry 3rd Normal Form Can Anyone Help??

    THIS IS THE SCENARIO, I HAVE PUT MY VERSION OF THE 3RD NORMAL FORM AT THE BOTTOM OF THE PAGE IN A DIFFERENT COLOUR, IM NOT SURE WHAT IM DOING WRONG OR IF IT IS AT ALL BUT PLEASE CAN SOMEONE TELL ME WHAT THE CORRECT ANSWER IS.

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    THERE IS NO CORRECT ANSWER

    some answers are more correct than others

    and sadly, there's no way we're gonna do your assignment for you

    sorry
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •