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  |
                                    ----------------------------