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

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

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!