Testbook Test Series: Databases - Database Normalization

Question

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$

Comments

Why $5$ FD's are given?

But 3NF decompsition need not be FD preserving always ?

Where you read,can you give me counter example? 

---

Sorry that was for BCNF not 3NF  :(

---

Yes

Answer 1

see this, you will understand better