Types of Join Dependencies

Edit Answers
123456789101112131415
Across
  1. 2. A type of outer join that includes all rows from the right table
  2. 5. A type of outer join that includes all rows from the left table
  3. 7. A join that automatically matches columns with the same name and datatype
  4. 8. A join that returns matching rows along with non-matching rows from one or both tables
  5. 9. A join that returns the Cartesian product of two tables
  6. 10. A join where a table is joined with itself
  7. 12. A join that returns only matching rows from both tables
  8. 14. A constraint specifying that a relation can be recreated by joining multiple projections
  9. 15. A join based on equality between specified columns
Down
  1. 1. A join that avoids repeated columns when matching attributes
  2. 3. A join that uses comparison operators like <, >, <=, >=, !=
  3. 4. A join dependency where no information is lost when relations are joined
  4. 6. A type of outer join that includes all rows from both tables
  5. 11. A join that returns rows from the first table that do *not* match with the second
  6. 13. A join that returns only rows from the first table that match with the second