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?

 1. Do the attribute names in this description follow the guidelines

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

for naming attributes? If not, suggest better names. Do you have any

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?

associative entities on your ERD? If so, what are the identifiers for

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

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!