TOPIC   : EXAMPLE OF  EXTENDED ER  DIAGRAM  WITH  EXPLANATION

HOSPITAL MANAGEMENT

There will be many employees in the hospital. Employees can be doctors, nurses, receptionist .Doctors will attend the patients .Doctor can be a trainee  , permanent or  a visiting doctor . A doctor can attend many patients. A patient is uniquely identified by patient id .It is  also characterized  by  patient  details,address, sex, name  and contact number .Patient details includes  date of admitted and date of discharge .Each person is assigned a room at a particular time duration .These rooms are governed by the nurses .Rooms is characterized by room  type and period .It is uniquely identified by room id. Records are kept for every patients .These records are maintained by receptionist .Each record is uniquely identified by the record number .It also has  the details  about  appoint ,patient id, description. Bills are generated  for both treatment and medicine provided to the patient .

STEP   1 : IDENTIFYING ENTITIES

  • Patient
  • Doctor
  • Rooms
  • Nurse
  • Employee
  • Record
  • Receptionist
  • Trainee
  • Visiting
  • Permanent

STEP   2  : IDENTIFYING RELATIONSHIPS

  • Ø A doctor can attend many patients. So cardinality  is 1:N.
  • Ø Each patient is assigned a room .So cardinality is 1:1
  • Ø Many nurse governs  each room .So cardinality is M:1
  • Ø A receptionist maintains many number of records .So cardinality is 1:N
  • Ø Every  patient  is paid bill for the treatment .So cardinality is 1:N
  • Ø Every patient is paid  bill for the medicines .So cardinality is 1:N
  • ER_PICTURE
  • STEP  3 : IDENTIFYING KEY ATTRIBUTES
    • Patient  – patient ID(PID)
    • Record  -Record no
    • Employee – Employee ID (EID)
    • Rooms – Room ID
    • Medicine –Code

    STEP 4 : IDENTIFYING OTHER RELEVANT ATTRIBUTES

    • Patient –

    Name, Sex, Patient details (pdetails), address , contact no

    • Record –

    Appointment , patient_id ,description

    • Employee –

    Salary, E_address ,sex ,NID ,E_name ,History ,Contact no

    • Rooms –

    Room type  , Period

    • Medicine –

    Quantity  ,Price

    STEP 5 : COMPLETED ER DIAGRAMS

    h7ithf1smk1

Advertisements