tuples

Question

Answer 1

Degree of relation is number of attribute in relational database.

Now consider a relation $R(A,B,C,D,E)$

A	B	C	D	E
5	6	7	8	9
6	8	9	2	3
4	7	9	4	2

Now consider the query $\sigma _{A< B}\left ( \pi _{A,B}\left ( \pi _{A,B,C\left ( R \right )} \right ) \right )$  which will evaluated to

A	B
5	6
6	8
4	7

So degree of relation is =2

Answer 2

ans should be 2 degree of a relation is the number of attributes in the table innermost projection operator will yield 3 attributes A,B,C the second  projection will give A,B 2 Attributes and finally oute select opeartion will give rows with 2 attributes  with condition A<B