Consider the following schema for STUDENT- Student (RollNo, Name, City, Father-Name, Branch, Sem, Per) Write the following queries in Relational Algebra: (i) List the records of students. (ii) List the records such students whose city is Mbd. (iii) List the records of those students whose Percentage marks is more than 75%.
Consider the following schema for STUDENT- Student (RollNo, Name, City, Father-Name, Branch, Sem, Per)
Write the following queries in Relational Algebra:
(i) List the records of students.
(ii) List the records such students whose city is Mbd.
(iii) List the records of those students whose Percentage marks is more than 75%.
(iv) List the records of those students whose Percentage marks is less than 40%.
(v) List the records of those students whose Percentage marks between 80 to 90%.
(vi) Show student’s name and City and branch who live in Delhi.
(vii) Show student’s RollNo, Name and Sem whose Percentage Mark is more than 80%.
Plz try to give solution of this question within 1hrs as it is very urgent plzz....
Step by step
Solved in 3 steps with 3 images
