21) Consider the following relational schemes for a library for a library database:
Book (Title, Author, Catalog_no, Publisher, Year, Price)
Collection (Title, Author, Catalog_no)
Which ofthe 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 schemes: Which of the following statements is true?
Answer is:
Book is in 2NF and Collection is in 3NF
Related Databases MCQ with Answers
Answer is:
integrity constraint
Answer is:
Transaction log
Answer is: