Questions tagged [relational-division]

Operation in relational algebra or in an RDBMS to partition relations. The inverse of a Cartesian product (CROSS JOIN).

E.F. Codd identified eight relational algebra operators in his defining paper "A Relational Model of Data for Large Shared Data Banks". Division is the least known and probably most complex of them. It is the inverse operation of a Cartesian product (CROSS JOIN in SQL).

It means partitioning a (bigger) table with rows from another (smaller) table. For requirements like:
"Find tuples that combine a particular value in one attribute with several values in another attribute."

A practical example:
"Find all clubs where Sue and John and James are members."

More information

52 questions
3
votes
2 answers

Writing SQL query equivalent to relational division of relational algebra?

EMPLOYEE (Ssn#, Fname, Lname, Bdate, Address, Sex, Salary, Super_ssn) WORKS_ON (Essn#, Pno, Hours) PROJECT (Pnumber#, Pname, Plocation) Question 1: Write an SQL query (equivalent to relational division of relational algebra) to retrieve the…
learningIT
  • 155
  • 1
  • 3
  • 7
0
votes
1 answer

Prove or disprove that `T=R÷S` implies `S=R÷T`?

Prove or disprove: Given that T=R÷S, it is implied that S=R÷T. My attempt: Let us take some R,S tables and we will divide R÷S: step 1: R S ==> T=R÷S ------------- --------- …
3SAT
  • 171
  • 3
  • 14