Question 7 A relational database contains two tables Student and Performance as shown below: The primary key of the Student table is Roll_no. For the Performance […]

Question 37 Consider the set of relations EMP(Employee-no, Dept-no, Employee-name, Salary) DEPT(Dept-no, Dept-name, Location) Write an SQL query to: (a) Find all employee names who work […]

Question 49 Given relations r(w, x) and s(y, z), the result of select distinct w, x from r, s is guaranteed to be same as r, […]

Question 40 Consider the following relations: Consider the following SQL query. SELECT S. Student_Name, sum(P.Marks) FROM Student S, Performance P WHERE S.Roll_No = P.Roll_No GROUP BY […]