Consider the following table and write relational algebra operations f

1.	Consider the following table and write relational algebra operations for the followingStudent RegnoNameMarkMark2Total101ABC183654102XYZ454893103ZYX384684104BCD454691105DEF324173(a) To display those tuples from STUDENT relation where total is greater than 90. (b) To display cnly Regno and Name of all students.
Answer» (a) σTotal>90(Student) (b) π_Regno,Name (Student)

Consider the following table and write relational algebra operations for the followingStudent RegnoNameMarkMark2Total101ABC183654102XYZ454893103ZYX384684104BCD454691105DEF324173(a) To display those tuples from STUDENT relation where total is greater than 90. (b) To display cnly Regno and Name of all students.

Answer»

(a) σTotal>90(Student)

(b) π_Regno,Name (Student)