Computer Sciences > Gate 2017 Set-1 > Relational Algebra
Consider a database that has the relation schemas EMP (EmpId, EmpName, DepId), and DEPT(DeptName, DeptId). Note that the DepId can be permitted to be NULL in the relation EMP. Consider the following queries on the database expressed in tuple relational calculus.
I. {t | ∃ u ∈ EMP (t[EMPName] = u[EmpName] ∧ ∀ v ∈ DEPT (t[DeptId] ≠ DeptId]))}
II. {t | ∃ u ∈ EMP (t[EMPName] = u[EmpName] ∧ ∃ v ∈ DEPT (t[DeptId] ≠ DeptId]))}
III. {t | ∃ u ∈ EMP (t[EMPName] = u[EmpName] ∧ ∃ v ∈ DEPT (t[DeptId] = DeptId]))}
II. {t | ∃ u ∈ EMP (t[EMPName] = u[EmpName] ∧ ∃ v ∈ DEPT (t[DeptId] ≠ DeptId]))}
III. {t | ∃ u ∈ EMP (t[EMPName] = u[EmpName] ∧ ∃ v ∈ DEPT (t[DeptId] = DeptId]))}
Correct : Relational Algebra
Similar Questions
Consider the following two relations, R(A,B) and S(A,C);
The total number of tuples obtained by evaluating the following expression σB<C(R ⨝R.A=S.AS) is...
Consider the following two relations, R(A,B) and S(A,C);
The total number of tuples obtained by evaluating the following expression σB<C(R ⨝R.A=S.AS) is...
Consider the following two relations, R(A,B) and S(A,C);
The total number of tuples obtained by evaluating the following expression σB<C(R ⨝R.A=S.AS) is...
Total Unique Visitors
Loading......