Relational Algebra (DB)

Discussion in 'OT Technology' started by purebad, Oct 4, 2006.

  1. purebad

    purebad I don't need your approval, right?

    Joined:
    Aug 25, 2006
    Messages:
    4,376
    Likes Received:
    0
    Location:
    Smyrna, GA
    If I have a set of values, and I need to check a relation to see if one of its attributes is in that set.

    For instance, a table like: pc(model, price, speed)

    and I had a set of models, How would you get the tuples from the table which has a model in the set of models I have with relational algebra?
     
  2. Peyomp

    Peyomp New Member

    Joined:
    Jan 11, 2002
    Messages:
    14,017
    Likes Received:
    0
    select * from PC where attribute=foo;

    ?

    Sorry, I never took that class. Sounds... fun, though.
     
  3. purebad

    purebad I don't need your approval, right?

    Joined:
    Aug 25, 2006
    Messages:
    4,376
    Likes Received:
    0
    Location:
    Smyrna, GA
    intro to databases, we are going over all the theory right now, I would rather be elbow deep in real querys :)
     
  4. skelm

    skelm New Member

    Joined:
    Jan 9, 2006
    Messages:
    868
    Likes Received:
    0
    Location:
    Australia
    Ack.. I hate the theory parts... I always learnt better at uni when I was actually coding / doing instead of learning the theory...
     
  5. Peyomp

    Peyomp New Member

    Joined:
    Jan 11, 2002
    Messages:
    14,017
    Likes Received:
    0
    Yeah, I never took the classes so I can't do the math representation of anything CS. Over the years I went back and brushed up on alot of stuff I missed, but my maths are still weak. Some day I will spend some time by the beach with nothing but math books for a month, and that will change... some day.
     

Share This Page