Write SQL statements for Queries PATIENT(#P_id, Pname, Address,) TREATMENT( #P_Id, ,D_id, Appointment _Date, Fees) DOCTOR(#D_id, Dname, Specilization, Salary) WARD(#P_Id, W_id. w name) a. Find total number of doctors who are child specialist. b. Find the name of all patients admitted to Special ward. c. Find Doctor name who treated ‘Arnav’ d. Find the date on which ‘Ravi met Dr. Amar. e. Delete all record of patient ‘Vijay’ f. Find all the patient name treated by Dr. Vasu’ g. Find total doctors specialization wise h. Find the patient name starting with letter ‘P’ f. Insert {2,ajay, kharghar } to PATIENT table. g Delete Dr. Akash name from database . h. Update address to Thane of PETIENT Ravi.

Relational Models

Four relational models are given for the entities Patient, Treatment, Doctor, and Ward

PATIENT

P_id | Pname | Address

TREATMENT

P_id | D_id | Appointment_Date | Fees

DOCTOR

D_id | Dname | Specialization | Salary

WARD

P_id | W_id | W_name

SQL Queries

a] Find a total number …