Question: You are asked to design the database for the new hospital to be built only for Surgery in California. Here is the list of information

 You are asked to design the database for the new hospital

You are asked to design the database for the new hospital to be built only for Surgery in California. Here is the list of information that you gather: Different departments (Heart, plastic, etc.) will be available for different kinds of surgery. Each department can be uniquely identified by a dame. Database also contains information about the address and phone number of the department. Department can have multiple surgeons to deal with different operations and tests. A surgeon has surgeonID, surgeonName, specialization and phone number. Each department is headed by a surgeon from some specific date. A department can offer varied number of operations. An operation has a unique opID, a opName and a description. Different kinds of tests for an operation is performed by one surgeon. There may be possibility of conducting multiple tests for some operation. Each test is uniquely tracked by testID and testName. A patient has an unique ID, name, location (home address or office address), date_admitted and date_discharged. A patient may be examined for multiple tests for some operation. Design an ER diagram describing the database discussed above Do not use the quaternary relationships. Also, specify the cardinality and participation constraints in the relationships. Write your assumptions if any. Transform this ER diagram into relational schema. Describe the relation - attributes and the constraints on the relations thus obtained

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!