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 sultsStep 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