Consider a relation R (A, B, C, D, E, F, G, H), where each attribute is atomic, and following functional dependencies exist
Consider a relation R (A, B, C, D, E, F, G, H), where each attribute is atomic, and following functional dependencies exist
CH → G
A → BC
B → CFH
E → A
F → EG
The relation R is ______
Show answerHide answer
Correct answer: (A) In 1NF but not in 2NF
Explanation
A⁺ contains all attributes except D, and D cannot be derived from any attribute, so D must be part of every key (e.g. AD, BD, ED, FD are keys). Then A → BC is a partial dependency of non-key attribute C on part of key AD, so R is in 1NF but not in 2NF.