STUDENT RegNO. - 101,102,103,104,105 Name - Preethi, Anupama, Ruksana, Nancy, Anu

Question

STUDENT 

RegNo	Name	Scores
101	Preethi	70
102	Anupama	68
103	Ruksan	94
104	Nancy	87
105	Anu	77

GRADE

RegNo	Name	Scores
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) σ (G RADE)

Grade = 'B+'

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

Answer 1

 1)

RegNo	Scores	Grade
103	Ruksana	94
104	Nancy	87

2) 

RegNo	Scores
101	70
102	68
103	94
104	87
105	77

3) 

RegNo	Scores	Grade
104	87	A
105	77	B+

4) 

RegNo	Scores	Grade
101	70	B+
105	77	B+

 5)

RegNo	Name
103	Ruksana
104	Nancy
105	Anu