Question: 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?

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

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?

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
Get step-by-step solutions from verified subject matter experts
