Describe each entity type in detail

[emohamud]

3. Describe each entity type in detail

• Ward

   WardNumber : Unique
   WardName
   Location
   NumOfBeds
   Phone
  
   Primary Key: WardNumber

• Staff

  StaffNumber
  Name        : Composite (firstName, lastName)
  Address
  Phone
  DOB
  Sex
  NIN
  Position
  Salary
  SalaryScale
  LocalDoctors
  Qualifications
  WorkExperience
  EmpolymentContract
  
  Primary Key: StaffNumber

• Patients

  PatientNumber   : Unique
  Name                  : Composite (firstName, lastName)
  Address
  Phone
  DOB
  Sex
  MaritalStatus
  DateRegistered
  NextOfKin
  
  Primary Key: PatientNumber

• PatientAppointment

  ApptNumber : Unique Name StaffNumber DateAndTime ExaminationRoom

  Primary Key: ApptNumber

• PatientMedication

  PatientNumber
  PatientName
  DrugNumber
  DrugName
  UnitsPerDay
  Method
  Date                   :Composite (StartDate, FinishDate)
  
  Primary Key: PatientNumber

• SurgicalAndNonsurgicalSupplies

  ItemNo             :Unique
  Name
  Description
  Quantity
  ReorderLevel
  CostPerUnit
  
  Primary Key: ItemNo

• PharmaceuticalSupplies

  DrugNumber DrugName Description Dosage Method Quantity ReorderLevel CostPerUnit

  Primary Key: DrugNumber

• WardRequisitions

  RequisitionNumber :Unique Name Place :Composite (WardNumber, WardName)

  Primary Key: RequisitionNumber

• Suppliers

  SupplierNumber SupplierName Address Phone Fax

  Primary Key: SupplierNumber