Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

PostgreSQL Up And Running A Practical Guide To The Advanced Open Source Database

Authors: Regina Obe, Leo Hsu

3rd Edition

1491963417, 978-1491963418

More Books

Students also viewed these Databases questions