Question: . Normalize the following relation into relations in 4NF. Indicate the functional dependencies, multivalued dependencies, primary keys (underlined), foreign keys (dashed underline), candidate keys, and

. Normalize the following relation into relations in 4NF. Indicate the functional dependencies, multivalued dependencies, primary keys (underlined), foreign keys (dashed underline), candidate keys, and specify any referential integrity constraints. Show the resulting ERD.

A hospital serves many patients. Each patient can have many charges, including their daily room charge, therapy, IV, radiology, etc. Each of these charges may be incurred by several patients, and the price is always the same. For example, the IV charge is $150 per day. A hospital also has many physicians on staff. A physician is on staff of only one hospital. A physician may admit patients, but a patient is admitted by only one physician.

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!