Relational Algebra
 

Ok, I'm having trouble with this particular assignment, specifically this final question:

For the (A), this is what I've came up with and I'll try my best to get the symbols going:

beta -> σbalance<0(account)
alpha -> πtypebeta
πtype(account-alpha)


It's my understanding that I select any account with negative balance and then select only the types which, then I remove any of those types within the account table that is contained within the alpha relations. Is that correct?

(B)

beta -> σbalance<0account
πtype(beta)

Again, it's my understanding that what I did was select any account that has negative balance and select the types, is that correct?

I think I'm basing those assumptions that the projection operations are removing any duplicates data