Question: Draw an ERD for Pine Bluff Hospital based on the following information: a. Each patient has an ID, a name, an address, and insurance information.

Draw an ERD for Pine Bluff Hospital based on the following information: a. Each patient has an ID, a name, an address, and insurance information. b. Each patient is assigned to a ward (room). c. Hospital staff includes doctors and nurses. d. Each doctor is identified by an ID, a name, an address, and a license e. Each nurse is characterized by an ID, a name, an address, and a certification f. Each nurse is assigned to zero or more wards. Each ward has at least one nurse assigned. g. Each doctor is assigned to zero or more patients. A patient may or may not have a doctor assigned, and they may have more than one doctor. h. Patients in the same ward may have different doctors but will always have the same nurse(s). i. Define a generalization hierarchy based on the similarities between the 2 types of hospital staff. Be sure to specify the necessary constraints for the hierarchy
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
