Question: Consider the following relations: Worker ( Pid , person - name, street, city, Contact, age, Gender ) works ( Pid , CID, salary ) Company
Consider the following relations:
WorkerPid personname, street, city, Contact, age, Gender worksPid CID, salary
CompanyCID companyname, city, contact managesPid managername
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
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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
