427 views
2 votes
2 votes
I have two doubts:

1) A natural join B

What will be the result when B don't have any tuple in it. Like in B their is relational algebra expression which is selecting Cars of green color but their is no green color car in table. What will be the result in this case.

2) A / B

In above divison if B is a relational algebra expression returning nothing ( like the B in case 1). What will be the result ?

Please log in or register to answer this question.

Related questions

1 votes
1 votes
2 answers
1
aditi19 asked May 8, 2019
1,223 views
Suppliers(sid, sname, address)Parts(pid, pname, color)Catalog(sid, pid, cost)Find the pids of the most expensive parts supplied by suppliers named Yosemite Sham
0 votes
0 votes
0 answers
2
kumar.dilip asked Oct 27, 2018
530 views
Online Site For practicing Relational Algebrahttps://dbis-uibk.github.io/relax/calc.htm
2 votes
2 votes
1 answer
3
learner_geek asked Dec 3, 2017
1,650 views
Consider the relations r1(P, Q, R) and r2(R, S, T) with primary keys P and R respectively. The relation r1 contains 2000 tuples and r2 contains 2500 tuples. The maximum s...
0 votes
0 votes
1 answer
4
aditi19 asked May 7, 2019
913 views
Given relationcatalog(sid, pid, cost)Find pairs of sids such that the supplier with the first sid charges more for some part than the supplier with the second sidwhat is ...