[prev] 4 [next]

Exercise 3: Relational Algebra

Using the same student/course/enrolment schema as above: 

Students(sid, name, degree, ...)
Courses(cid, code, term, title, ...)
Enrolments(sid, cid, mark, grade)

Write relational algebra expressions to solve the problem

  • find all students who passed COMP9315 in 18s2
  • for each student, give (student ID, name, mark)
Express it as a sequence of steps, where each step uses one RA operation.