Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started