Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hospital ERD Exercise Assume you are the database designer for Polk County. The County has 17 hospitals. A hospital has one or more wards. Each

image text in transcribed

Hospital ERD Exercise Assume you are the database designer for Polk County. The County has 17 hospitals. A hospital has one or more wards. Each ward is located in only one hospital A ward has many employees who work there and employees sometimes work in multiple wards. Each hospital has on its staff one or more doctors. These doctors are on the staff of only one hospital Doctors admit lots of patients, but patients are admitted by only one doctor. Each patient may incur any number of charges (x-ray, pharmacy, lab, etc.). Charges are incurred by any number of patients. Required: Follow th instructions for the Database ERD practice provided to you to complete the ERD. . 2. For each of your entities, make up a primary key attribute and add it to the ERD. Underline 3. 4. Embed foreign keys as appropriate to link the tables together in the ERD. Write "FK" next to primary keys For each of your entities, add 3 attributes that would be uscful in the database and add it to the ERD. foreign keys. Hospital ERD Exercise Assume you are the database designer for Polk County. The County has 17 hospitals. A hospital has one or more wards. Each ward is located in only one hospital A ward has many employees who work there and employees sometimes work in multiple wards. Each hospital has on its staff one or more doctors. These doctors are on the staff of only one hospital Doctors admit lots of patients, but patients are admitted by only one doctor. Each patient may incur any number of charges (x-ray, pharmacy, lab, etc.). Charges are incurred by any number of patients. Required: Follow th instructions for the Database ERD practice provided to you to complete the ERD. . 2. For each of your entities, make up a primary key attribute and add it to the ERD. Underline 3. 4. Embed foreign keys as appropriate to link the tables together in the ERD. Write "FK" next to primary keys For each of your entities, add 3 attributes that would be uscful in the database and add it to the ERD. foreign keys

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting For Decision Making And Control

Authors: Jerold Zimmerman

10th International Edition

1260565475, 9781260565478

More Books

Students also viewed these Accounting questions

Question

Where is the position?

Answered: 1 week ago