engineering recuitment RPSC Programmer Mock Test 2024 DBMS Integrity Constraints and Normal Form Functional Dependency
Relation R has 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.
The relation R is
1
in 1NF, but not in 2NF.
2
in 2NF, but not in 3NF.
3
in 3NF, but not in BCNF.
4
in BCNF.