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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.