Question: Consider the following relations: Worker ( Pid , person - name, street, city, Contact, age, Gender ) works ( Pid , CID, salary ) Company

Consider the following relations:
Worker(Pid, person-name, street, city, Contact, age, Gender) works(Pid, CID, salary)
Company(CID, company-name, city, contact) manages(Pid, manager-name)
Write the following Query in relational algebra:
(i) How many senior citizen female worker is working in the company?
(ii) Display the female worker details who are getting salary more than 10000.
(iii) Display the worker details who are working in Chennai.
(iv) Display the manager name of all male worker.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!