Question 36 Consider a database that has the relation schema EMP (EmpId, EmpName, and DeptName). An instance of the schema EMP and a SQL query on […]

Question 10 Consider a relation geq which represents “greater than or equal to”, that is, (x,y) ∈ geq only if y >= x. create table geq […]

Question 38 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 9 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 […]