a. Insert a new tuple in the relation patient.
INSERT INTO Patient VALUES ('P008', 'Ramesh', 'Dhangadhi', 'Male', 'Fever');
b. List all the patients who were checked by doctors Pankaj and Rubi.
SELECT p.PID, p.Pname FROM Patient p JOIN Appointment a ON p.PID = a.PID JOIN Doctor d ON d.DID = a.DID WHERE d.Dname = 'Pankaj' OR d.Dname = 'Rubi';
c. List name and id of doctors whose salary is less than Rs. 120,000.
SELECT Dname, DID FROM Doctor WHERE salary < 120000;
d. Find name of patients whose name begins with 'Ru'.
SELECT Pname FROM Patient WHERE Pname LIKE 'Ru%';
e. Increase salary of all doctors by 10% who works in Forensic department.
UPDATE Doctor SET salary = salary * 1.10 WHERE department = 'Forensic';