Crowdly
Add to Chrome
INTRO. TO DATABASE MGMT. SYST.
Looking for INTRO. TO DATABASE MGMT. SYST. test answers and solutions? Browse our comprehensive collection of verified answers for INTRO. TO DATABASE MGMT. SYST. at moodlenew.iitd.ac.in.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
Consider a relation R(M, N, O, P, Q, R, S) with the following functional dependencies: 1. MN → OP 2. O → Q 3. P → R 4. Q → S
The candidate key is MN.
What is the highest normal form this relation satisfies?
Consider a relation R(X, Y, Z, W, V) with the following functional dependencies: 1. XY → Z 2. Z → W 3. W → V 4. V → X
The candidate key is XY.
Which functional dependency (or dependencies) violate BCNF?
Given the following SQL query:
employee(empid, empName, empAge)dependent(depId, eId , depName, depAge)
SELECT empId FROM employeeWHERE empId NOT IN ( SELECT e.empId FROM employee e JOIN dependent d ON e.empId = d.eId WHERE e.empAge <= d.depAge);
Which of the following Relational Algebra expressions correctly represents this query?
Consider a relation R(A, B, C, D, E, F) with the following functional dependencies: 1. A → B 2. BC → D 3. D → E
Which of the following functional dependencies must also hold?