In a hospital each surgeon is assigned to a particular operating room (OR) on the same day each week (e.g., Dr. Smith is in OR22 every Wednesday). A surgeon gets exactly one such assignment and each OR gets some use. Other doctors (not surgeons) don't have ORs assigned to them. ORs are described by their (unique) room number and size. Each doctor is described by a (unique) Id, name, and phone

number. Draw an E-R diagram (neatly) that describes this enterprise and represents all these facts.

What will be an ideal response?

See figure for two possible solutions.



Computer Science & Information Technology

You might also like to view...

Which of the following is NOT a handle on a graphic inserted into a worksheet?

A) Round selection handle B) Rotation handle C) Flip handle D) Square selection handle

Computer Science & Information Technology

What is the logarithm of n to the base 2?

What will be an ideal response?

Computer Science & Information Technology