[Answered]: Develop a drug prescription system to assist a…

Develop a drug prescription system to assist a pharmacist in filling prescriptions. You need to specify the assumptions that are used in your design, if there is any. A drug is a medical substance used in the treatment of a disease, having a name, chemical formula, and medical action. A drug has a unique name, such as acetaminophen, metronidazole, or tretinoin. A drug may come in many forms, including pills, capsules, gels, ointments, tinctures, suspensions, and powders, for example. Every drug has a controlled substance classification relevant to its addictive properties and a functional classification, which is a broad categorization of the purpose of the drug, such as antibiotics, antifungals, sedatives, antihistamines, beta-blockers, and tranquilizers, for example. A compound is a particular form, size, and strength of a drug or combination of drugs produced by a particular manufacturer. Compounds may be purchased through distributors. The manufacturer and distributor has a unique company number, name, and address. There may be various compounds of a drug. A compound may have secondary ingredients besides the drugs, which are the primary ingredients. A compound may have a brand name assigned by the manufacturer, such as Tylenol, MetroGel 0.75%, or Retin-A Gel 0.025%. The strength is the concentration or amount of a drug in a given compound. Thus, the compound MetroGel 0.75% has a 0.75% concentration or metronidazole. In the case of pills, strength is the amount of the drug in the compound, expressed in grams. Finally, there are possibly harmful drug interactions and allergies to consider. Drug interactions usu- ally involve a pair of drugs, but might involve three or more. Allergies are summarized with allergy identifiers, which specify allergic reaction mechanisms. A drug may be assigned any number of allergy codes to indicate an allergic mechanism for vulnerable patients. Most drugs do not have any allergy codes. The system should assist with the following tasks: ?? Manage information about drugs and compounds. ?? Determine distributors and manufacturer of a compound. ?? Detect allergies and drug interactions.