Consider the following relational database:
- Patient(PID, Pname, Paddress, Pgender, disease)
- Doctor(DID, Dname, Daddress, Department, salary)
- Appointment(PID, DID, time)
Write SQL statements for the following:
- Insert a new tuple in the relation patient.
- List all the patients who were checked by doctors Pankaj and Rubi.
- List name and id of doctors whose salary is less than Rs. 120,000.
- Find name of patients whose name begins with 'Ru'.
- Increase salary of all doctors by 10% who works in Forensic department.