Grade 12B Midterm Exam: ERDs, EHR, and SQL

Which of the following best describes an Entity in an ERD?

• A specific piece of data, such as a phone number

• A unique object, such as a patient or doctor, that stores data

• A connection between two attributes

• A rule that enforces data integrity

What is the purpose of a primary key in an entity?

• To store foreign key relationships

• To uniquely identify each record in the table

• To hold large amounts of data

• To create duplicate records

Fill in the blank: In an ERD, a ________ represents the link between two entities.

Which of the following is an example of a one-to-many relationship in an EHR system?

• A patient has multiple doctors

• A hospital has multiple patients

• A patient has only one medical record

• A doctor has only one specialization

Match the following ERD components to their definitions:

• A unique identifier for a record

• Relationship

• A connection between two entities

• Attribute

• A property of an entity

• Entity

• A table that exists in the database

• Primary key

What is the main purpose of an EHR system?

• To store digital versions of a patient’s medical history

• To replace hospital staff

• To diagnose illnesses

• To manage hospital finances

Which of the following is NOT a typical table in an EHR database?

• Patients

• Appointments

• Invoices

• Movie Reviews

Fill in the blank: In an EHR system, the ________ table usually contains attributes like patient_id, name, date_of_birth, and contact information.

Which of the following attributes is most likely to be a foreign key in an EHR database?

• patient_id in the Patients table

• doctor_id in the Doctors table

• patient_id in the Appointments table

• name in the Patients table

Match the following EHR database tables with their expected attributes:

• patient_id, name, date_of_birth

• Doctors

• appointment_id, patient_id, doctor_id

• Prescriptions

• prescription_id, patient_id, medication

• Appointments

• doctor_id, name, specialty

• Patients