G'day Professor,
There is two CONSTRAINTs that make me very confused on what should I done with it:
A: ONLY 1 SURGEON(=1 Appointment) IN 1 ROOM IN 1 DATE_HOUR :
Please note that more than one surgeon can use the same room at different
times. However, a surgeon will only use one room at a time
B: PATIENT can ONLY BOOK 1 SURGEON IN 1 DATE(of Appointment entity)
The patient is allowed to schedule appointments with different surgeons on the same day if needed. However, the patient cannot have multiple appointments with the same surgeon on the same day
> AT first, I using relationship to build this constraint but I couldnt find a way to do it. So I build 2 entities as schedule tables of surgeons and of the rooms. But when I went to the lab, I got a feedback that I have too many entities (Which I think maybe I does). So I when back and try do find another solution, but it took hours and to me, unless we can use foreign keys (Which is not yet), there is no other solution to me. So I confusing right now that should I just skip it and let the foreign keys do the job or should I just let those 2 entities as solution.
> The Lab assitant is very great with help but the feedback in this is really made me confused, so can you please give some feedback about this. Thank you very much for your time.