ER diagram (for hospital)

This is a part of hospital diagram.

Each nurse can be assigned to different wards on different days of the week so a nurse must be supervised by another one who is assigned to the same ward on the same day of the week as the nurse or the nurse may be supervised by different nurses on different days of the week, but both the nurse and the supervisor nurse must be assigned to the same ward on the same day in which the supervision takes place.

I thin the entity is

ward(WardNO, WardName) , nurse (staffNo,Name, WarsNo)

and tell me the degree and participant of relation

can anyone please help me..

asked Dec 17 '11 at 12:20 AM in Default

sun 1
21 ● 3 ● 3 ● 4

Can many nurses be supervised by the same supervisor nurse?

Dec 17 '11 at 03:51 AM Raj More

(comments are locked)

3 answers:

Raj is right, you need to add a some sort of event tracking table. Your new diagram has no capability for transactional data or time-tracking. A ward shift table solves it elegantly. Your diagram should not have the self-reference of nurse to their supervisor, because that relationship is indirect or incidental. The nurses are assigned to the ward, and the supervising nurse is assigned to the ward. For any given day, a nurse and supervising nurse can be matched by the fact that they are both related to the same ward-shift instance.

What may have happened is your user-base gave you requirements in user language, which often looks at what they see day-to-day. The user does not see the difference between first-level and second-level relationships.

By relating supervisors and nurses directly, you'll be creating a maintenance nightmare.

answered Dec 17 '11 at 12:43 PM

Alendar
40 ● 2

(comments are locked)

this is the picture. we must make some change into two entity (ward and nurse).

so can you please help me..

alt text

answered Dec 17 '11 at 08:24 AM

sun 1
21 ● 3 ● 3 ● 4

You should edit your original question and add details there.

Dec 17 '11 at 10:44 AM Raj More

My original answer stands. A nurse is not going to be supervised by the same nurse for every shift. Their shifts are not always going to overlap. Also, you may need history of who was a supervisor nurse 2 weeks ago on a particular day for audit reasons.

Dec 17 '11 at 10:46 AM Raj More

Thanks for helping me

Dec 17 '11 at 10:57 AM sun 1

(comments are locked)

It only seems logical to me that many nurses would report to one Supervisor nurse. I would probably start with something like this until more requirements are understood

alt text