Assume (Author, Title) is the key for both schemas. Which one of the following is true ?
A. Both Book and Collection are in BCNF
B. Both Book and Collection are in 3NF
C. Book is in 2NF and Collection in 3NF
D. Both Book and Collection are in 2NF
Answer:B
Assume (Author, Title) is the key for both schemas. Which one of the following is true ?
A. Both Book and Collection are in BCNF B. Both Book and Collection are in 3NF C. Book is in 2NF and Collection in 3NF D. Both Book and Collection are in 2NF