select name from person, author, article where name != “John Doe” AND person.pid = author.pid AND author.aid = article.aid AND title = select title from …
Tag: relational-algebra
Maximum number that can be returned by 2 Natural Joins
Given relations A(a,b,c), B(e,f), C(d,g,h), where A has 800 tuples, B 200 and c 500. In worst case gives the expression A * B * C ( with * natural join) : a) 800 tuples b) 200 tuples c) 500 tuples …
Can all SQL queries be represented in Relational Algebra, Domain and Tuple relational calculus
My query includes a having and count or all in. How are these represented in RA/DRC/TRC? Would I have to simplify my SQL query even more? Here is a simplified example: empl(employee (primary key), …