CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 47

Prescription PrescriptionID, MedicationID, BillingAmount,
TransactionDateTime, ClinicLogID, PatientID A prescription is
identified by a single prescription order. Prescriptions are
• made to one or more patients but only one patient at a time;
• made by one or more pharmacists but only one pharmacist per
prescription;
• recorded on one or more clinics but only one clinic per prescription;
and
• administered by one or more nurses but no one prescription can be
administered by more than one nurse.
PrescribedMedicationPrescriptionID, MedicationID, ItemPrice,
QuantityDispensed Prescribed medication is part of a prescription and
records medication dispensed per prescription. Prescribed medication
must be able to associate multiple medications sold on a single
prescription number.
Patient Patient Number, First Name, Last Name, Address, City, State,
Zip, Phone Number A patient can be associated with multiple
prescriptions, but any one prescription is to one and only one patient.
A prescription can occur without a patient registering in the system
(e.g., an unconscious patent arrives by ambulance in the emergency
room and receives life-saving emergency treatment).
Using an appropriate drawing/data modelling tool, develop an ERD
that meets the following guidelines.
• Draw the entities with their attributes.
• Indicate the relationships between the entities using Crow‘s Foot
notation. You will need to determine the cardinality and optionality for