Guiding Questions

Fill in the blank: Step 3 in the Data Modeling Process is _________.

• Logical Model

• Physical Model

• Conceptual Model

• Data Analysis

Fill in the blank: Step 4 in the Data Modeling Process is _________.

• Physical Model

• Logical Model

• Conceptual Model

• Data Analysis

What does an entity represent in a database?

• A real-world object (person, place, thing)

• A fictional character

• A computer program

• A mathematical equation

An entity is represented as a (a)   in a database.

Provide an example of an entity that might be used in a pharmacy database to manage information about all patients, their prescription, and all medications.

• Patient

• Prescription

• Medication

• Pharmacy

What are the key components to consider when planning a database entity?

• Attributes/fields, Keys (primary and foreign keys), Relationship to other entities

• Only Attributes/fields

• Only Keys (primary and foreign keys)

• Only Relationship to other entities

Identify the attributes for the entity 'Prescription' in the Pharmacy Database following instructions in Activity 2 on the SA worksheet.

• Patient ID, Medication, Dosage, Frequency

• Doctor ID, Pharmacy Location, Insurance Details

• Prescription Date, Expiry Date, Refill Information

• Pharmacy Name, Address, Contact Number