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 ... |
Get Database Systems: Concepts, Design and Applications now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
