Sorry, it's not clear how one could "look for the relational algebra", especially if you have some particular schema. I thought one could just learn some relational algebra. So, it's not quite clear what can help you. May be this:
http://en.wikipedia.org/wiki/Join_%28SQL%29[
^].
If you have some particular concerns, you have to tell us about them. There is nothing special about your schema.
—SA