Consider the following specification Employee(personid,personname,street,city) Works(personid,companynum,salary)
Company(companynum,city)
Manages(personid,managername)
Solve the following queries in SQL and Relational Algebra
a. Find the names of employees work for “FBC” b.Find the name of all employees who live in same city as the company for which
they work.
c. Give all employees of “FBC” a 10% salary hike.
d. Find the company details with the most employees.