• edited by
795 views

1 Answer

3 3 votes

Remember what division means in basic operations – 

When $S$ is empty $(\pi_A(R)$ x $S)$ is also empty. (The cartesian product of any non-empty with an empty set gives an empty set)

Further $\pi_A(\pi_A(R)$ x $S$ – $R)$ is also empty. (Subtracting from an empty set also yields an empty set).

Thus $R/S$ when $S$ is empty is $R$ itself. So, all $4$ tuples (SID, CID) from $Enrolled$ relation should be present in the result query.

 

Learn the literal meaning of division operator and how we come up with the above relational algebra expression for that operator – https://youtu.be/Zzjy-q667r0

• edited by
Position:
Show:

Related questions

0 0 votes
1 1 answer
67
67 views
GO Classes asked 4 days ago
67 views
Consider the relation $\mathrm{Sailors}(\mathrm{sid},\mathrm{sname},\mathrm{rating},\mathrm{age})$ and the following TRC expression: $$\{S\mid \neg(S\in \mathrm{Sailors})...
1 1 vote
0 0 answers
1.2k
1.2k views
ajaysoni1924 asked Mar 26, 2019
1,161 views
Consider the employee database shown here. Give expressions in tuplerelational calculus and domain relational calculus for each of the followingqueries:a. Find the names ...
1 1 vote
1 1 answer
2.2k
2.2k views
ajaysoni1924 asked Mar 26, 2019
2,221 views
Consider the relational database given below where the primary keys areunderlined. Give an expression in tuple relational calculus for each of thefollowing queries:a. Fin...