I am a philosopher and am doing my first steps in relational algebra. So here is a puzzle:
Let say that we have a relation R with attributes 'R.a' and 'R.b'. Is it possible to make a renaming and natural join operations on R and receive a triple (a, b, a) as a result?
If I make the following steps:
- rename R to S.
- rename all attributes in S to 'S.a', 'S.b'.
- rename 'S.b' on 'R.b' and
- make a natural join of R and S.
Will it work? How do I write such a request properly?