š Question
#1520
Consider the following relational schemes 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
ā
Correct Answer
B. Both Book and Collection are in 3NF only
š”
Explanation
The relation Collection is in BCNF: Its given that {Author, Title} is the key and there is only one functional dependency (FD) applicable to the relation Collection {i.e. Title Author ā> Catalog_no}.
āØļø Press
A
B
C
D
to select