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

avatar image

sun 1
21 3 3 5

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

more ▼

answered Dec 17, 2011 at 04:27 AM

avatar image

Raj More
1.8k 82 87 90

(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

more ▼

answered Dec 17, 2011 at 08:24 AM

avatar image

sun 1
21 3 3 5

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

avatar image

Alendar
40 1 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:

x280
x97

asked: Dec 17, 2011 at 12:20 AM

Seen: 4276 times

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

Copyright 2016 Redgate Software. Privacy Policy