Construct an Entity Relationship Diagram for the following medical clinic: 1) The clinic keeps track of patients and doctors. In addition, it needs to keep data about each consultation that any patient receives., as well as the medical tests requested. A consultation takes place between a patient and a doctor. Each consultation has a date, a medical note from the doctor, and may have one or more medical prescriptions. 2) Each Patient has a unique id (Patient_no), a name (Patient_name), date of birth, a derived attribute (age), and address in terms of city, street_name, and postal_code. The patient may register with more than one address. 3) Each doctor has the following attributes; a medical license no, a specialty, a year of graduation and multiple addresses in terms of city, street_name, and zipcode. 4) Each consultation has the following attributes: consultation_date, Patient_name, Doctor_name, medical_note, as well as any number of prescribed medications and/ or medical tests. 5) Each patient may have zero or multiple consultations. 6) However, each medical test (e.g. blood test, X-Ray) is owned by one and only one patient. The medical test has its name (e.g. Lower Back X-Ray), and the results report as attributes. 7) Each patient has associated with him/her zero to any number of consultations. State any assumptions you make very clearly. What issues are not very clear and need further investigation?