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 features makes it easy to replicate formats from one text selection to another?

A. AutoFormat B. Format Painter C. Format Copy D. Format Correction

Computer Science & Information Technology

As shown in the accompanying figure, XML Schema supports ____ types of content.

A. two B. three C. four D. six

Computer Science & Information Technology

Which of the following is TRUE about sharing software?

A) When a desktop computer uses software from a server, the software files remain permanently in RAM of the desktop computer. B) Even if software is installed on a server, portions of it must also be installed on the desktop computers. C) If the server where the software is installed is not functioning, the other desktop computers can still use the software. D) Software only has to be installed and updated on one computer.

Computer Science & Information Technology

Asset classification can be carried out in many ways, but the easiest method is to label assets with basic high/low terms.

Answer the following statement true (T) or false (F)

Computer Science & Information Technology