kay21 0 Newbie Poster

Hi everyone,

Can somebody tell me how to solve the below question please.

Student (StudentId, StudentName, Major, Year)
Module (ModuleId ,ModuleName, CreditHours, Department)
Class (ClasssId, ModuleId, InstructorName)
GradeSheet (StudentId, ClassId, ModuleId, Grade)
Prerequisite (ModuleId, PrereqId)


Write an optimum relational algebra expression for the following SQL query

Select StudentID, ModuleId ,ModuleName, ClasssID, InstructorName, Grade
From Student, Module, Class, Grade Sheet
Where Student.StudentID = GradeSheet.StudentID
And GradeSheet.ModuleId =Module.ModuleId
And Module.ModuleId = Class.ModuleId
And Grade = A
And Major ='Graphics'
And (Department ='MultiMedia' Or Department ='Gaming');

Thank you very much.