Register

MadeEasy Test Series 2018: Databases - Relational Algebra

• edited by
548 views
2 votes
2 votes

Hello,

I always have trouble solving queries where the inner most query is referring to the main query. Can someone please explain how the result is obtained for the following question.

Thank You

The provided answer is: Age more than 30 and not works for every project with project name database

• edited by
User Avatar

Please log in or register to answer this question.

Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

1 votes
1 votes
1 answer
1
nikkey123 asked Jan 29, 2018
1,646 views
MadeEasy Test Series 2018: Databases - Relational Algebra
Consider the following database table Supplier (Sid, Sname, rating) Parts (Pid, Pname, color) Catalog (Sid Pid, cost) Which of the following SQL query correct representation to retrieve Sid’s who supplied every red part.
Consider the following database tableSupplier (Sid, Sname, rating)Parts (Pid, Pname, color)Catalog (Sid Pid, cost)Which of the following SQL query correct representation ...
User Avatar
1 votes
1 votes
1 answer
2
charul asked Jan 16, 2018
410 views
MadeEay Test Series 2018: Databases - Relational Algebra
here for 1st relation algebra operation the join operation is given without condition , will it be considered as natural join or cartesian product?
here for 1st relation algebra operation the join operation is given without condition , will it be considered as natural join or cartesian product?
User Avatar
–1 votes
–1 votes
0 answers
3
Himanshu Kashyap asked Jan 12, 2019
664 views
MadeEasy Test Series 2019: Databases - Relational Algebra
PLEASE EXPLAIN WHEATHER IT WOULD BE SOME EC DEPARMENT OR ALL EC DEPARTMENT I THINK ALL BECOZ IT IS SELECTION EID OF STUDENT WHO HAVE NOT ENROLLED IN ANY COURSE OF EC
PLEASE EXPLAIN WHEATHER IT WOULD BE SOME EC DEPARMENT OR ALL EC DEPARTMENT I THINK ALL BECOZ IT IS SELECTION EID OF STUDENT WHO HAVE NOT ENROLLED IN ANY COURSE OF EC
User Avatar
Link Copied!