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?

doctor_id becomes the foreign key because the primary key on the "one" side of the relationship becomes the foreign key on the "many" side of the relationship.

patient_id becomes the foreign key because the primary key on the "one" side of the relationship becomes the foreign key on the "many" side of the relationship.

patient_id becomes the foreign key because a PATIENT must see a DOCTOR during the appointment time.

doctor_id becomes the foreign key because a PATIENT requires a doctor during an appointment time

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!