Hospital ERD Quiz 1 12B

What is the primary key in the Patient entity?

• FirstName

• PatientID

• Email

• PhoneNumber

Which of the following best describes the relationship between Patient and Appointment?

• One-to-One

• One-to-Many

• Many-to-One

• Many-to-Many

In the ERD, which entity is responsible for storing patient diagnoses and treatments?

• Appointment

• MedicalRecord

• LabTest

• Billing

What is the role of the Doctor entity in relation to the Appointment entity?

• A doctor can have multiple appointments.

• An appointment can have multiple doctors.

• A doctor can only have one appointment at a time.

• A doctor must be assigned to a single patient for all appointments.

Which entity is directly related to storing medication details for a patient?

• Appointment

• Billing

• Prescription

• LabTest

The Billing entity is related to which of the following?

• Patient and Appointment

• Patient and MedicalRecord

• Doctor and Appointment

• Doctor and LabTest

What type of relationship exists between the MedicalRecord and Prescription entities?

• One-to-One

• One-to-Many

• Many-to-One

• Many-to-Many

What is the primary key of the Appointment entity?

• AppointmentDate

• DoctorID

• AppointmentID

• PatientID

Which entity stores test results related to a patient?

• LabTest

• Prescription

• MedicalRecord

• Appointment

If a doctor needs to access all their previous diagnoses, which entity should they refer to?

• Appointment

• MedicalRecord

• Billing

• LabTest