정규화_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)