807 views
2 votes
2 votes

Consider the following relations A, B and C:


 

A
Id Name Age
12 Arun 60
15 Shreya 24
99 Rohit 11


 

B
Id Name Age
15 Shreya 24
25 Hari 40
98 Rohit 20
99 Rohit 11
C
Id Phone Area
10 2200 02
99 2100 01

How many tuples does the result of the following relational algebra expression contain? Assume that the schema of A∪B is the same as that of A.

(A∪B)⋈A.Id>40∧C.Id<15C

2 Answers

Best answer
2 votes
2 votes

2 tuples are possible.

After union

ID Name Age
12 Arun 60
15 Shreya 24
99 Rohit 11
98 Rohit 20
25 Hari 40

After join

A.Id name Age C.id Phone Area
99 Rohit 11 10 2200 02
98 Rohit 20 10 2200 02

2 tuples only

selected by

Related questions

1 votes
1 votes
2 answers
2
aditi19 asked May 8, 2019
1,224 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
4
gatecrack asked Dec 10, 2018
482 views