Design a relational database of patient-encounter and pharmacy orders such that a doctor orders a medicine over the Internet for a patient after the doctor-patient encounter. The information included for patient-information table, doctor-information table, patient-doctor encounter table, and new relational tables have to be formed optimally to include patient's medications, medications side- effects, medication administration schedule, dosage, duration of the medication, patient's pharmacy name, pharmacy-id, pharmacy address, pharmacy phone number, drug cost, patient's insurance- provider, insurance-id, insurance approval of the medicine brand. Show the relational tables, primary keys in each relational table, and the connectivity