plz answers database

2:05 till 19% IV - SQL Queries : Consider the following Relational schema and Relations instances. (30 points) Patient (ID:char(9), P_name:varchar(25), City: varchar(50)) Prescription (Patient_ID:char(9), Medicine_code:char(5), Clinic:varchar(25)) Medicine (code:char(5), m_name:varchar, Ingredients:varchar, Price:float) Write SQL queries that will do the following Patient Prescription ID P.name City Patient ID Medicine.code Clinic 112233445 Adam Beirut 112233445 Nx306 Well Nutrition 998877666 Bob Saida 112233445 Pa003 Healthy Clinic 556677889 Sara Zahle 998877665 Pa003 Safe Clinic 443322445 Eve Tyre 443322445 Ad500 Safe Clinic 443322445 Nx306 Well Nutrition Medicine code Mname Ingredients Price Pa003 Panadol Potassium, Paracetamol, Starch 5.5 Nx306 Nexume 20.0 Magnesium, Polysorbate, Glyceryl Acetaminophen, Paracetamol Ad500 Adol 3.0 Ap800 Aspirin Acetysalicylic Acid, Starch 8.55 List the name and the ID of all patients * Your answer 2:05 till 19% List the price of Medicine called Nexume * Your answer Find the names of patients who have at least one prescription. Your answer Find the names of patients who have a prescription that contains the medicine called Panadol. Your answer Find the average price of medicines * Your answer Find total price of medicines prescribed for a patient called Adam. * 2:05 till 19% List the price of Medicine called Nexume * Your answer Find the names of patients who have at least one prescription. Your answer Find the names of patients who have a prescription that contains the medicine called Panadol. Your answer Find the average price of medicines * Your answer Find total price of medicines prescribed for a patient called Adam. * 2:05 till 19% List the price of Medicine called Nexume * Your answer Find the names of patients who have at least one prescription. Your answer Find the names of patients who have a prescription that contains the medicine called Panadol. Your answer Find the average price of medicines * Your answer Find total price of medicines prescribed for a patient called Adam. * 2:05 V till 19% docs.google.com/forms/d/e 13 STU_NUM STU_LNAME STU_MAJOR 211343 Sanders Finance Statistics 200128 Smith Accounting 199876 Marketing, Accounting 199913 Ortiz Mathematics 223456 Smith Statistics DET_CODE ACCT ACCT MKTG MATH MATH DEPT_NAME Accounting Accounting Marketing Mathematics Mathematics DEPT_PHONE 4356 4356 4378 3420 3420 Jones STU_NUM (STU_LNAME, STU_MAJOR,DEPT_NAME) DEPT_CODE (DEPT_NAME, DEPT_PHONE) The table is susceptible to anomalies. Provide examples of insertion, deletion, and update anomalies * Your answer Describe and illustrate the process of normalizing the table into 3NF * Your answer IV - SQL Queries : Consider the following Relational schema and Relations III 2:05 till 19% Find the name of all medicines that have an ingredient called 'paracetamol * Your answer Find the name of all patients whose ID ends with 445'* Your answer * Add new medicine to the database Your answer Change the price of Panadol medicine to 4 * Your answer Submit Never submit passwords through Google Forms. This form was created inside of Lebanese International University Report Abuse III 2:05 et ul 19% Find the names of the patients who have prescriptions from the Well Nutrition' clinic * Your answer Find the maximum price of a medicine * Your answer Find the name of the medicine(s) that have the lowest price * Your answer Find the name(s) of patient(s) who have more than one prescription * Your answer Find all the information about all medicines sorted in the ascending order of price. * TIL