Consider a database that has the relation schemas EMP(EmpId, EmpName, DeptId),…
GATE · 2017 · CS · Set 1 · Computer Science & IT
Consider a database that has the relation schemas EMP(EmpId, EmpName, DeptId), and DEPT(DeptName, DeptId). Note that the DeptId can be permitted to be NULL in the relation EMP. Consider the following queries on the database expressed in tuple relational calculus.
I. { | ∃u ∈ EMP(t[EmpName] = u[EmpName] ∧ ∀v ∈ DEPT(t[DeptId] ≠ v[DeptId]))}
II. { | ∃u ∈ EMP(t[EmpName] = u[EmpName] ∧ ∃v ∈ DEPT(t[DeptId] ≠ v[DeptId]))}
III. { | ∃u ∈ EMP(t[EmpName] = u[EmpName] ∧ ∃v ∈ DEPT(t[DeptId] = v[DeptId]))}
Which of the above queries are safe?
- A.
I and II only
- B.
I and III only
- C.
II and III only
- D.
I, II and III
Attempted by 170 students.
Sign up free to check your answer
Sign up freeLoading lesson…