The GATE Grind

GATE 2008 CS – Question 69

Databases · Integrity Constraints and Normal Forms · 2 marks · Multiple choice

Schemas: Book(Title, Author, Catalog_no, Publisher, Year, Price); Collection(Title, Author, Catalog_no). FDs: Title Author→Catalog_no; Catalog_no→Title Author Publisher Year; Publisher Title Year→Price. {Author, Title} is a key for both. Which is true?

  1. Both Book and Collection are BCNF.
  2. Both are3NF only.
  3. Book is2NF and Collection is3NF.
  4. Both are2NF only.

Practise this question in The GATE Grind →

Show answer and explanation

Correct answer: (C) Book is2NF and Collection is3NF.

Explanation

We are sorry we couldn't write detailed soluition for this, we are working on it!, please consider asking your own AI, its just 2-3 clicks with very minimum effort

More Integrity Constraints and Normal Forms questions

All Integrity Constraints and Normal Forms questions →