Consider the relation scheme \(R = (E, F, G, H, I, J, K, L, M, N)\) and the…
GATE · 2014 · CS · Set 1 · Computer Science & ITTPSC Computer/IT Posts · 2025 · Senior Informatics Officer · Section D
Consider the relation scheme \(R = (E, F, G, H, I, J, K, L, M, N)\) and the set of functional dependencies
\(\left\{ \{E, F \} \to \{G\}, \{F\} \to \{I, J\}, \{E, H\} \to \{K, L\}, \ \{K\} \to \{M\}, \{L\} \to \{N\}\right\}\)
on \(R\). What is the key for \(R\)?
- A.
\(\{ E, F\}\) - B.
\(\{ E, F, H\}\) - C.
\(\{ E, F, H,K,L \}\) - D.
\(\{ E \}\)
Attempted by 943 students.
Show answer
Correct answer: B
The worked solution is available to enrolled students.
Video solution available to enrolled students.
Explore the full course: Iocl Engineers Officers Grade A Paper 2
Loading lesson…