engineering recuitment GATE CSE 2023-24 Test Series DBMS Integrity Constraints and Normal Form Normal Form
Consider a relation R having eight attributes ABCDEFGH. Fields of R contain only atomic values. F={CH→G, A→BC, B→CFH, E→A, F→EG} is a set of functional dependencies (FDs) so that F+ is exactly the set of FDs that hold for R.
Which of the following is/not true about R?
1
R is in 1 NF
2
R is in 2 NF
3
R is in 3 NF
4
R is in BCNF