Relational Algebra Cartesian Product
We will use two example tables
EMPLOYEE
| NAME | EMP_ID | DEPT_NAME |
James
|
HR22 | HR |
| PAUL | HR33 | HR |
| Sam | FIN22 | FINANCE |
DEPARTMENT
| DEPT_NAME | MANAGER |
HR
|
STEVE |
| FINANCE | CLAIR |
EMPLOYEE X DEPARTMENT = (3 x 2) = NUMBER OF ROWS
RELATES EVERY TUPLE TO EVERY OTHER TUPLE
No comments:
Post a Comment