x

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..

more ▼

asked Dec 17, 2011 at 12:20 AM in Default

sun 1 gravatar image

sun 1
21 3 3 4

Can many nurses be supervised by the same supervisor nurse?
Dec 17, 2011 at 03:51 AM Raj More
(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

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][1]

[1]: http://img502.imageshack.us/img502/1200/1217201172553amnurses.jpg
more ▼

answered Dec 17, 2011 at 04:27 AM

Raj More gravatar image

Raj More
1.7k 80 82 84

(comments are locked)
10|1200 characters needed characters left

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

so can you please help me..

![alt text][1]

[1]: http://www11.0zz0.com/2011/12/17/16/426917858.jpg
more ▼

answered Dec 17, 2011 at 08:24 AM

sun 1 gravatar image

sun 1
21 3 3 4

You should edit your original question and add details there.
Dec 17, 2011 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, 2011 at 10:46 AM Raj More
Thanks for helping me
Dec 17, 2011 at 10:57 AM sun 1
(comments are locked)
10|1200 characters needed characters left

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.
more ▼

answered Dec 17, 2011 at 12:43 PM

Alendar gravatar image

Alendar
40 2

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x244
x77

asked: Dec 17, 2011 at 12:20 AM

Seen: 3766 times

Last Updated: Dec 17, 2011 at 02:02 AM