16
Consider the following relational schemas for a library database : Book (Title, Author, Catalog_no, Publisher, Year, Price) Collection(Title, Author, Catalog_no) with the following functional dependencies : I. Title, Author → Catalog_no II. Catalog_no → Title, Author, Publisher, Year III. Publisher, Title, Year → Price 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 & Explanation
18
Consider the schema R = {S, T, U, V} and the dependencies S → T, T → U, U → V and V → S If R = (R1 and R2) be a decomposition such that R1 ∩ R2 = φ then the decomposition is
A
not in 2NF
B
in 2NF but not in 3NF
C
in 3NF but not in 2NF
D
v
Answer & Explanation
