Directions (Q96–100): An organization maintains a database with five attributes A, B, C, D, E. Consider the universal relation R(A, B, C, D, E) with functional dependency set F = {A → BC, D → E, BC → D, A → D}. All attributes are simple and atomic.
Identify the normal form in which relation R belong to
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: B. 2 NF
Explanation
The key is the single attribute A, so there are no partial dependencies (2NF). BC → D and D → E are transitive dependencies on non-keys, so R is not in 3NF.
More Database Management Systems questions
- Identify the redundant functional dependency in F
- Assume that given table R is decomposed in two tables R (A, B, C) 1 with functional dependency set f = {A → B, A → C} 1 and R (A, D, E) FD…
- Which of the following has same expressive power with regard to relational query language? (a) Relational algebra and domain relational cal…
- Which of the following features is supported in the relational database model?
- With respect to relational algebra, which of the following operations are included for mathematical set theory? (a) Join (b) Intersection (…
- In relational databases, if relation is in , then which of the following is true about relation R ?