SLIDE
SLIDE
SLIDE #9 DIVIDE
The DIVIDE operation is the inverse of the product operation.
Therefore, we can divide the relation called product by the
student relation, to obtain the course relation.
We illustrate the results below:
Product relation
----------------------------------------------------------
| name | age | sex | state | course | teacher | room |
----------------------------------------------------------
| fred | 19 | m | FL | math | joe | A01 |
| fred | 19 | m | FL | spanish | phil | A07 |
| fred | 19 | m | FL | history | tom | A03 |
| ann | 23 | f | CA | math | joe | A01 |
| ann | 23 | f | CA | spanish | phil | A07 |
| ann | 23 | f | CA | history | tom | A03 |
----------------------------------------------------------
Divided by: Relation student Quotient: Course Relation
------------------------------- ----------------------------
| name | age | sex | state | | course | teacher | room |
------------------------------- ----------------------------
| fred | 19 | m | FL | | math | joe | A01 |
| ann | 23 | f | CA | | spanish | phil | A07 |
------------------------------- | history | tom | A03 |
----------------------------