Question: 1-When constructing an ERD for a PET entity, we make up our own primary key called pet_id. We refer to this type of primary key
1-When constructing an ERD for a PET entity, we make up our own primary key called "pet_id". We refer to this type of primary key as which of the following?
| Lost key | ||||||||||||||
| Composite key | ||||||||||||||
| Virtual key | ||||||||||||||
| Simple key 2- DOCTOR and PATIENT have a one-to-one relationship in which a PATIENT must see a doctor during an appointment, but a DOCTOR may have the appointment time free. Which primary key, "doctor_id" or "patient_id" becomes the foreign key in the relationship?
|
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
