Hi guys,
Apologies for the long message, my main question is at the bottom.
I have to create a database, and just finding doing the erd a bit tricky.
I have to create a medical appointment database, yet do not know the best way of
approaching it. The db will be created in access and Asp.
Basically, it involves 2 main entities.
– Patient
– Doctor.
To put it in a nutshell,
Doctors have a roster, they should be able to select 7 day working week, to indicate when they are available and at what time. So for Doctor Jim, he can select three weeks in advance and which day and time he is available. So he can say select Mondays, Wednesdays and Thursdays as his/her available days. Then they can select the timeslot of when they are available. Usually the timeslots are divided by 30min, 15min, it really depends on the doctor.
Patient:
When the patient comes to do a booking online, he/she must be able to book an appointment with a specific doctor, and the time that doctor has allocated for appointments. Once that booking has been done, there can be no other bookings in that timeslot, as we want to prevent cross-bookings. So basically, the patient can only see appointment time periods that are available. They can choose up to 3 time periods. The patient enters all details such name, phone, DOB, and email. A confirmation email is sent to both patient and selected Doctor.
——
To expand on the doctor entity..
The info varies according to each doctor and needs. To be filled out and altered by doctor from time to time.
DOCTOR
