Consider the following relational schemes for a library database: Book (Title,…
PYQ GATE 2008
Consider the following relational schemes for a library database: Book (Title, Author, Catalog_no, Publisher, Year, Price) Collection (Title, Author, Catalog_no) with in 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 schemes. Which of the following statements is true?
- A.
Both Book and Collection are in BCNF
- B.
Both Book and Collection are in 3NF only
- C.
Book is in 2NF and Collection is in 3NF
- D.
Both Book and Collection are in 2NF only
Attempted by 205 students.
Sign up free to check your answer
Sign up freeLoading lesson…

