Write Relational Algebra for relation student (sid, sname, address, gender, age)

Consider the relation:

student(sid, sname, address, gender, age)

 

Write relational algebra(RA) for the following:

  1. To display name of student whose age is greater than 15.
  2. To remove the record of the student who are from Kathmandu.
  3. To update address of student to Kathmandu whose sid is 'S1101'.

a. To display name of student whose age is greater than 15.

π sname ( σ age > 15 ( student ) )

 

b. To remove the record of the student who are from Kathmandu.

student ← student - ( σ address = 'Kathmandu' ( student ) )

 

c. To update address of student to Kathmandu whose sid is 'S1101'.

student ← π sid, sname, address = 'Kathmandu', gender, age ( σ sid = 'S1101' ( student ) ) ∪ ( σ sid ≠ 'S1101' ( student ) )

Asked in Year
2022
Course
BBM
University
TU