Question: Consider the following relational database and give an expression in the relational algebra for each of the following queries: employee ( person _ name, street,
Consider the following relational database and give an expression in the relational algebra for each of the following queries:
employee personname, street, city
works personname, companyname, salary company companyname, city
manages personname, managername
i
ii find the company with smallest payroll.
iii Find the names and cities of residence of all employees who work for First bank corporation. iv Give all managers in the database a percent salary raise, unless the salary would be greater
than Rs In such cases give only a percent raise.
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
