Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2009
    Posts
    1

    Wink Entity Relationship Design

    Hi

    I am pursuing to be a Business Analyst & I am supposed to come up with an ERD for an outpatient hospital management system. I managed to come up with a few Entities:

    Physician
    Patient
    Department
    Service
    Appointment
    Nurse
    Visit
    VisitType
    Referal
    ReferralType
    Payment
    Invoice
    Gender
    BloodGroup
    FamilyHistory
    PatientHabits
    Diagnos

    But I am struggling to come up with a proper ERD. Pls assist.
    Thanking you all in anticipation.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by Assist Please View Post
    Pls assist.
    nuh-uh, sorry, that's not how it works here

    for homework assignments, ~you~ do the work, all we do is point you in the right direction

    here's a start: gender is an attribute, not an entity
    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
  •