GATE 2008 CS – Question 69
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?
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