Teaching UGC NET Mock Test Series 2025 (Paper 1 & 2) DBMS Integrity Constraints and Normal Form Functional Dependency
Comprehension Passage
Direction: Answer question based on the problem statement given below:
An organization needs to maintain database having five attributes A, B, C, D, E. These attributes the functionally dependent on each other for which functionally dependency set F is given as: F : (A → BC, D → E, BC → D, A → D}. Consider a universal relation R(A, B, C, D, E) with functional dependency set F. Also all attributes are simple and take atomic values only.Assume that given table R is decomposed in two tables
R1(A, B, C) with functional dependency set f1 = {A → B, A → C} and R2(A, D, E) with FD set F2 = {A → D, D → E}
Which of the following option is true w.r.t. given decomposition?1
Dependency preservation property is followed
2
R1 and R2 are both in 2 NF
3
R2 is in 2 NF and R3 is in 3 NF
4
R1 is in 3 NF and R2 is in 2 NF