정규화_3

테이블 (5)

appointment

  • appointment_id — INT
  • patient_id — INT
  • doctor_id — INT
  • department_id — INT

department

  • department_id — INT
  • depart_name — VARCHAR(100)

doctor

  • doctor_id — INT
  • department_id — INT
  • name — VARCHAR(100)

medical_record

  • record_id — INT
  • patient_id — INT
  • doctor_id — INT
  • department_id — INT

patient

  • patient_id — INT
  • name — VARCHAR(100)