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 16s1
- for each student, give (student ID, name, mark)
|
![[prev]](icon/prev.gif){kind=icon}
![[next]](icon/next.gif){kind=icon}