edited
284 views
0 votes
0 votes
Given the relations

Emp(name, salary, dept_no)

Dept(dept_no, dept_name, addr)

which of the following queries cannot be expressed using the basic relational algebra operations.

a)Department addr of every employee.

b)Employees whose name is the same as their department name

c)The sum of all employees salaries

d)All employees of a given department

Please explain by giving queries for each option.
edited

Please log in or register to answer this question.

Related questions

0 votes
0 votes
0 answers
2
aashijn asked Apr 28, 2022
1,331 views
employee (person-name, street, city)works (person-name, company-name, salary)company (company-name, city)manages (person-name, manager-name) a. Find the names of all empl...