1,324 views
1 votes
1 votes

Book claims that below query translates to relational algebra expression $P/Q$. Can anyone explain how does the below query translates to relational algebra expression $P/Q$?

Assume $Q$ has attributes $B_1,B_2,...,B_m$ and that $P$ has in addition the attributes $A_1,A_2,...,A_n$.

 How above query equates to relation algebra expression $P/Q$?

1 Answer

1 votes
1 votes

$\prod$ A1, A2...An(P) - (($\prod$ A1, A2...An(P) $\times$ $\prod$B1, B2...Bn(Q)) - $\prod$A1, A2...An(P))

Related questions

1 votes
1 votes
1 answer
2
khushtak asked Jan 20, 2016
822 views
Can anyone suggest me how to learn about sql and relational algebra and calculus for gate?as i feel this is an important topic and one 2 marks ques will be asked. I can u...
1 votes
1 votes
2 answers
3
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