Create an ERD based on below given requirements using Gliffy tool (www.gliffy.com). Requirements Midtown Memorial Patients Drug Dispense Database keeps track of the following information. For each patient, it keeps track of a unique patient identifier, patient birthdate, gender, first name and last name. The patient can either be more than 18-year-old or less than 18-year- old. For patient, less than 18-year-old, guardian name is also stored. For patient, more than 18-year-old, information like his employment status and job role is stored. For each nurse, it keeps track of a unique nurse ID and the nurse name. For each ingredient, it keeps track of the unique ingredient identifier and the ingredient name. For each drug, it keeps track of a unique drug ID, the drug name and the drug coating type. For each drug intake event by a patient it keeps track of the drug intake event number (unique within a patient, but different patients could have the same drug intake event number for their separate drug intake events), the drug intake event date and the time. Each ingredient must be contained in at least one drug, but it may be contained in many drugs. Every drug can contain many ingredients, but they must contain at least one. For every instance of an ingredient contained in a drug it keeps track of the dosage of the ingredient in the drug A drug may contradict several other drugs if they are taken at the same time, but a drug does not have to contradict any other drugs. A drug may be contradicted by many other drugs, but it does not have to be contradicted by any. Each drug must be included in at least one drug intake event, but it may be included in many. Each drug intake event must include at least one drug, but it may include many. For each instance of a drug included in a drug intake event it keeps track of the quantity Each nurse can administer several drug intake events, but it does not have to administer any. Each drug intake event must be administered by one nurse. When nurse administer the event, a supervisor must supervise her work in the event. The supervisor can be identified by a name. Each drug intake event is related to one patient. A patient can have many drug intake events, but they may not have any Submission Cle