Page 1 of 1
Q2: Consider the relation for published books: BOOK (Book_title, Authorname, Book_type, Listprice, Author_affil, Publish
Posted: Thu Jun 02, 2022 8:21 am
by answerhappygod
- Q2 Consider The Relation For Published Books Book Book Title Authorname Book Type Listprice Author Affil Publish 1 (28.56 KiB) Viewed 11 times
Q2: Consider the relation for published books: BOOK (Book_title, Authorname, Book_type, Listprice, Author_affil, Publisher), Author_affil refers to the affiliation of author. Suppose the following dependencies exist: Book-title→→ Publisher, Book_type Book_type Listprice → Authorname→→ Author_affil Answer the following
questions i. What normal form is the relation in? Explain you answer [3pts] ii. Apply normalization until you cannot decompose the relations any further. State the reasons for every decomposition you perform