Results 1 to 9 of 9
  1. #1
    Join Date
    Oct 2009
    Posts
    4

    Normal form voilations and fixing(Normalisation)

    Hello everyone,
    This is something i have been stuck on for quite a while now.
    Can you please help me following tables.

    Normal forms violated in the following designs and fix them. There may be multiple normal form violations in the design.
    1)PATIENT
    patient_id
    patient_fname
    patient_lname
    patient_street
    patient_city
    patient_state
    patient_zip
    patient_phone
    doctor_id
    doc_fname
    doc_lname
    doc_phone
    doc_beeper
    2)PATIENT
    patient_id
    insurance_company
    patient_fname
    patient_lname
    patient_street
    patient_city
    patient_state
    patient_zip
    patient_phone
    insurance_contact_first
    insurance_contact_last
    insurance_phone


    Thank you
    Maheja

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    what is this, some kind of homework assignment?
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Oct 2009
    Posts
    4
    Quote Originally Posted by r937
    what is this, some kind of homework assignment?
    you are right, try to solve and help this issue.

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    What is your question?
    George
    Home | Blog

  5. #5
    Join Date
    Jun 2007
    Location
    London
    Posts
    2,527
    he just wants us to do his homework George

  6. #6
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    I'd rather be riding on the Tiger 800 or the Norton

  7. #7
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    that article on r937.com is by Paul Litwin

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

  8. #8
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Quote Originally Posted by r937
    that article on r937.com is by Paul Litwin


    ok so I lied, if the site had been working when I posted the link I may have caught that
    I'd rather be riding on the Tiger 800 or the Norton

  9. #9
    Join Date
    Oct 2009
    Posts
    4

    hi

    Thank you for your help.


Posting Permissions

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