Relation dept year(dept name, total inst 2007, total inst 2008, total inst…
2025
Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here the only functional dependencies are from dept name to the other attributes. This relation is in
- A.
Fourth NF
- B.
BCNF
- C.
Third NF
- D.
Second NF
Attempted by 217 students.
Show answer & explanation
Correct answer: B
Answer: b
Explanation: The relation has a functional dependency from dept name to all other attributes. Since dept name is the only determinant and it is a candidate key, the relation satisfies BCNF. BCNF requires that every determinant is a candidate key, which is true here. Therefore, the relation is in BCNF. It is not in 4NF because there are no multi-valued dependencies to consider.