Question

1. You are given the following relational schema Employee(ename, street, city, salary, deductions) Works(ename, branch-name) Deputation(ename, org-name, returning date) Branch(branch-name, city) Manages(ename, manager-name) Write relational algebra expressions to answer the following queries: a)Retrieve the details of employees whose deductions are less than 10% of their salaries. b)Retrieve the details of branches located in Mumbai. c)Retrieve the details of employees whose deductions are less than 10% of their salaries and who live in Hyderabad. d)Retrieve the details of employees whose salary is 10,000 or deductions are 5,000 but all of whom live in Mumbai. e)Find the names of all employees. f) Find the names of all those employees who work for the branch ABC. g)Retrieve the names of employees whose deductions are less than 10% of their salaries. h)Find the names of employees

Answer 1

Answer:

ऊ ए ऐ ओ भैया को फिर से एक है