Assume (Author, Title) is the key for both the schema which one of the following statements is correct?
A. Both book and collection are in BCNF only
B. Both book and collection are in 3NF only
C. Book is in 2 NF and collection is in 3 NF
D. Both book and collection are in 2 NF only
Answer:C
Assume (Author, Title) is the key for both the schema which one of the following statements is correct?
A. Both book and collection are in BCNF only B. Both book and collection are in 3NF only C. Book is in 2 NF and collection is in 3 NF D. Both book and collection are in 2 NF only