Consider the relations STUDENT and GRADE given above and predict the output

Question

                         STUDENT

Reg No	Name	Score
101	Preethi	70
102	Anupama	68
103	Ruksana	94
104	Nancy	87
105	Anu	77

                     GRADE

Reg No	Name	Score
101	70	B+
102	68	B
103	94	A+
104	87	A
105	77	B+

Consider the relations STUDENT and GRADE given above and predict the output of the following relational operations in table format. 

1. σ (STUDENT) Score > 80 

2. π (STUDENT) RegNo, Score 

3. σ (GRADE) RegNo <103 

4. σ (GRADE) Grade = ‘B+’

5. π _{RegNo, Name} ( σ_{Scores >70}(STUDENT))

Answer 1

1.

Reg No	Scores	Grade
103	Ruksana	94
104	Nancy	87

2.

Reg No	Score
101	70
102	68
103	94
104	87
105	77

3. 

Reg No	Scores	Grede
104	87	A
105	77	B+

4. 

Reg No	Scores	Grede
101	70	B+
105	77	B+

5.

Reg No	Name
103	Ruksana
104	Nancy
105	Anu