4 - Databases Scenario Physicians place medication orders for patients specifying the drug, dosage, frequency and route. Examples of route include oral, intramuscular, and intravenous. An order can be active or discontinued. When reviewing orders, the most clinically relevant time is the time that the order will start. The pharmacy assigns each order a unique identifier.
Nurses carry out medication orders and administer medications to patients at the appropriate times.
Assume that medications are always administered using the dose and route specified in the order. Nursing assigns a unique identifier to every drug administration. Queries Determine the frequency of administration for a particular drug that was ordered for a given patient. Determine all the drugs that are currently ordered for a patient. Determine the dosages and routes of the drugs were administered to the patient today.