Question: Convert the conceptual database design shown below to logical database design. Correct errors, if any. Clearly show all PKs and multiplicities. State all your assumptions.

Convert the conceptual database design shown below to logical database design. Correct errors, if any. Clearly show all PKs and multiplicities. State all your assumptions. EMBED Visio.Drawing.11 Take the following requirements into considerationsThere many different types of operations that should be stored in the database. For example liposuction, brain surgery shall also be stored in the database in addition to the tumor-removal and c-section operations.At the end of a c-section one or more children may be born. It is necessary top store gender, timeofBirth and Birthstatus of each child. There are two values for status: Alive, Dead. The BirthStatus field must be flexible but controlled. For each tumor a size is stored. Assume that only one tumor I removed in each operation for simplicity.The equipments used in operations together with the medicine they utilize should be stored in the database. Note that only one medicine is used for each equipment in a given operationThere can be many doctors participating in an operation. For each doctor the responsibility in each operation must be stored in the DB.Each doctor is required to go through psychological tests a number of times e

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!