2 votes 2 votes The number of tables required to convert the relational schema $R(A, B, C, D, E, F, G, H)$ into $3NF$ with following functional dependency is ________ $A\rightarrow DG$ $AB\rightarrow E$ $D\rightarrow C$ $E\rightarrow F$ $G\rightarrow H$ Databases testbook-test-series databases database-normalization + – jatin khachane 1 asked Dec 27, 2018 • edited Jan 10, 2020 by Lakshman Bhaiya jatin khachane 1 881 views answer comment Share Follow See all 9 Comments See all 9 9 Comments reply Show 6 previous comments Lakshman Bhaiya commented Dec 27, 2018 reply Follow Share Why $5$ FD's are given? But 3NF decompsition need not be FD preserving always ? Where you read,can you give me counter example? 0 votes 0 votes jatin khachane 1 commented Dec 27, 2018 reply Follow Share Sorry that was for BCNF not 3NF :( 0 votes 0 votes Lakshman Bhaiya commented Dec 27, 2018 reply Follow Share Yes 0 votes 0 votes Please log in or register to add a comment.
Best answer 8 votes 8 votes see this, you will understand better Lakshman Bhaiya answered Dec 27, 2018 • selected Dec 27, 2018 by jatin khachane 1 Lakshman Bhaiya comment Share Follow See all 0 reply Please log in or register to add a comment.