## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

No credit card required

### Review Questions

 1 What do you understand by the term normalization? Describe the data normalization process. What does it accomplish? 2 Describe the purpose of normalising data. 3 What are different normal forms? 4 Define 1NF, 2NF and 3NF. 5 Describe the characteristics of a relation in un-normalised form and how is such a relation converted to a first normal form (1NF). 6 What undesirable dependencies are avoided when a relation is in 3NF? 7 Given a relation R(A, B, C, D, E) and F = (A → B, BC → D, D → BC, DE → φ), synthesise a set of 3NF relation schemes. 8 Define Boyce-Codd normal form (BCNF). How does it differ from 3NF? Why is it considered a stronger from 3NF? Provide an example to illustrate. 9 Why is 4NF preferred to BCNF? 10 A relation ...

## With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

No credit card required