Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Do the attribute names in this description follow the guidelines for naming attributes? If not, suggest better names. Do you have any associative entities

1. Do the attribute names in this description follow the guidelines for naming attributes? If not, suggest better names. Do you have any associative entities on your ERD? If so, what are the identifiers for those associative entities? Does your ERD allow a project to be created before it has any employees assigned to it? Explain. How would you change your ERD if the Billing Rate could change in the middle of a project?

image text in transcribed

2. How did you model SECTION? Why did you choose this way versus alternative ways to model SECTION?

image text in transcribed

3. Did you draw more than one relationship between physician and patient? Why or why not? Did you include hospi-tal as an entity type? Why or why not? Does your ERD allow for the same patient to be admitted by different physicians over time? How would you include on the ERD the need to represent the date on which a patient is admitted for each time he or she is admitted?

image text in transcribed

EMPLOYEE PX Employee ID Name Address Project ID Birthdate Billing Rate . Billing Employee ID PROJECT Project_ ID PK Project_Name Start Date 1 Section Number COURSE Schedule d SECTION Semester_ID Course Name Units Semester Year Admits PHYSICIAN PATIENT PK Physician_ID PK Patient_ID Specialty Patient_N ame TREATMENT PK Treatment Detail Date Time Re sults

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

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Databases questions

Question

Briefly discuss the advantages and disadvantages of automation.

Answered: 1 week ago