introduction to Database Management System

Question 6 a) Consider the relation Book (book Title, authorName, booklype, price, authorAddress, publisher). The relation has only one candidate key and it is (bookTtitle, authorName). The functional dependencies that hold are: IFD ZED TED bookTitle, authorName bookType, price, author Address, publisher bookTitle publisher, book_type book Title price authorName + author Address 1. [1 pt] Explain why book is not in BCNF. Write no more than 2 lines. relation to be BCWF First it should be 3 NF I since there exist partial dependence in 3 NF 2. [2 pts] Give a BCNF decomposition. Show your work and justify every step. relation Not RI ( Book title publisher, Book type, adress) Rz (Author name , author aaress) R3 (look title, auther name)