Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    2

    Relational Algebra

    I got these tables:

    Code:
    R
    -------------
    | a | b | c |
    -------------
    | 1 | 2 | 3 |
    | 1 | 1 | 2 |
    | 0 | 3 | 2 |
    | 1 | 1 | 3 |
    | 2 | 1 | 2 |
    -------------
    
    S
    -------------
    | a | b | d |
    -------------
    | 0 | 1 | 0 |
    | 0 | 2 | 1 |
    | 2 | 1 | 2 |
    | 1 | 2 | 1 |
    | 1 | 1 | 4 |
    | 1 | 2 | 5 |
    | 1 | 2 | 3 |
    -------------
    What's the cartisian product of the two? It had been clear if the attributes in the tables have had diffrent names. But since they have the same, are those related?

  2. #2
    Join Date
    Oct 2003
    Posts
    5
    the cartesian product is the same as if they had different names.

  3. #3
    Join Date
    Oct 2003
    Posts
    2
    Thanks.

    I misread the assigment. It was t * r not t x r. In other words a natural join, not the cartisian product =)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •