Consider the Employee Database

Employee (emp_name, street, city, date_of_joining)

Works(emp_name, company_name, salary)

Company (company_name, city)

Manager (emp_name, manager_name)

i)Modify the database so that “Deepa” lives in “Pune”

     UPDATE Employee 
     SET city=’Pune’ 
     Where emp_name=’Deepa’

ii)Give all employees of “XYZ corporation” a 10% rise in salary

     UPDATE Works 
     SET salary=salary*1.10 
     WHERE company_name=’XYZ …