Teaching UGC NET Mock Test Series 2025 (Paper 1 & 2) DBMS Integrity Constraints and Normal Form Functional Dependency
In a schema R(A, B, C, D, E, F, G, H), each field of R contains only atomic values.
F = (CH → G, A → BC, B → CFH, E → A, F → EG) is a set of functional dependencies so that F + is exactly the set of FDs that holds 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