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(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?
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?
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 → BC 2. C → D 3. B → E 4. E → F
Using the attribute closure method, is A → F derivable from the given FDs?