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. Determine who ordered a particular drug for a patient and who administered it. Problems Read the scenario carefully, and create a list of concepts using singular nouns for the type names.