Register

queries

• edited
480 views
0 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.

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← Previous · dbms queriesNext → · R S Aggarwal Quantit...
← Previous in category · dbms queriesNext in category → · #indexing
Position:
Show:

Related questions

1 1 vote
1 1 answer
132
132 views
GO Classes asked Oct 2
132 views
GO Classes DPP | GATE CS, DA | DBMS | SQL Queries
The database contains relations $\mathrm{animals}$ and $\mathrm{visits}$, with $\mathrm{aid}$ identifying an animal.Which SQL query returns the names of animals that visi...
3 3 votes
1 1 answer
253
253 views
GO Classes asked Oct 1
253 views
GO Classes DPP | GATE CS, DA | DBMS | SQL Queries
Relation $\mathrm{R}(\mathrm{at1},\mathrm{at2},\mathrm{at3})$ contains: $$\begin{array}{|c|c|c|} \hline \mathrm{at1} & \mathrm{at2} & \mathrm{at3} \\ \hline 12 & 15 & 510...
0 0 votes
1 1 answer
140
140 views
GO Classes asked Oct 1
140 views
GO Classes DPP | GATE CS, DA | DBMS | SQL Queries
A concert-ticket system contains $\mathrm{Sales}$ and $\mathrm{Payment}$.Relevant rules are:a row is placed in $\mathrm{Sales}$ when a purchase application is made; if pa...
2 2 votes
1 1 answer
136
136 views
GO Classes asked Oct 1
136 views
GO Classes DPP | GATE CS, DA | DBMS | SQL Queries
Consider the relation: $$\begin{array}{c}\mathbf{EmployeeQualification} \\[4pt]\begin{array}{|c|c|}\hline\mathrm{EmployeeCode} & \mathrm{Qualification} \\\hline\mathrm{S0...