written 8.0 years ago by | • modified 3.0 years ago |
Consider the following employee database
Employee (empname, street, city, date_of_joining)
Works (empname, company_name, salary)
Company (company_name, city)
Manages (empname, manager_name)
Write the sql queries for the following statements:
i. Modify the database so that ‘john’ now lives in ‘mumbai’
ii. Give all the employees of ‘ABC corporation’ a 10% raise
iii. List all the employees who live in same city as their managers
iv. Find all the employees who earn more than average salary of all the employees of their company
Mumbai University > Information Technology > Sem 3 > Database Management System
Marks: 10M
Year: Dec 2013