updated: 2022-01-23_12:32:31-05:00


Cartesian Product

  • Combines information from two relations
  • Denoted with X
    • eg: instructor X teaches
  • constructs tuple of the result out of each possible pair
  • If there are duplicate names for attributes, append name of origin before it like: instructor.ID
  • Basically, the cross product
  • Most likely you should filter this result by the common attribute (Primary Key)