Which of the following expressions should be used to find the name and address of all students who study in the ‘Science’ department?
The relational schemas are:
Student(Sno, name, address, age)
Department(Dno, Dname, Snumber, building)
1
\(σ_{name, address}(∏_{Dname ='Science'}(Department ⋈_{Snumber = Sno} (Student))\)
2
\(∏_{name, address}(σ_{Dname ='Science'}(Department ⋈_{Snumber = Sno} (Student))\)
3
\(σ_{Dname ='Science'}(Department ⋈_{Snumber = Sno} (Student)\)
4
\(∏_{name, address, Science}(Department ⋈_{Snumber = Sno} (Student))\)