1. Engineering
  2. Computer Science
  3. consider the following relation for published books bookbook title authorname...

Question: consider the following relation for published books bookbook title authorname...

Question details

Consider the following relation for published books: BOOK(Book title, Author_name, Book type, List price, Author affil, Publisher) Author_affil refers to the affiliation of author. Suppose the following dependencies exist: Book title Publisher, Book type Book type List price Author_name > Author affil (a) What normal form is the Book relation in? Why? (b) Decompose Book into 2NF relations. . (c) Decompose Book into 3NF relations.
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution