WorksheetsGuiding Questions
Total questions: 7
Worksheet time: 4mins
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
