Question: 24 pts Consider the following database schema, and for each entity, identify any primary and/or foreign keys. If there is more than one value, write


24 pts Consider the following database schema, and for each entity, identify any primary and/or foreign keys. If there is more than one value, write both, separated by a comma (or commas). If none, write the word none. Time Attem 1 Canvas is very specific as pertains to capitalization so use the case listed! If capital put capital, if lower case use lower case! If none, use none (lower case). Tip** Use scrap paper to draw the ERD - it can help. Room in accommodations, phone) Prin Foreign Key(s): I Physician (physicianID, name, phone, specialty) Foreign Key(s): Primary Key(s): Patient (patientNo, name, address, date-admitted, date discharged, physicianID, location) Room (location, accommodations, phone) Primary Key(s): Foreign Key(s): 1 I Physician (physicianID, name, phone, specialty) Primary Key(s): Foreign Key(s): Patient (patientNo, name, address, date-admitted, date discharged, physicianID, location) Primary key(s): Foreign Key(s): Iter description) Prima Foreign Key(s): Charges (patientNo, itemCode, charge)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
