Chapter 10 Normalization
State True/False
| 1. | True |
| 2. | False |
| 3. | False |
| 4. | True |
| 5. | True |
| 6. | True |
| 7. | True |
| 8. | True |
| 9. | False |
| 10. | True |
| 11. | True |
| 12. | False |
| 13. | True |
| 14. | True |
| 15. | True |
Tick (✓) the Appropriate Answer
| 1. | (d) |
| 2. | (a) |
| 3. | (d) |
| 4. | (b) |
| 5. | (c) |
| 6. | (a) |
| 7. | (d) |
| 8. | (d) |
| 9. | (c) |
| 10. | (c) |
| 11. | (c) |
| 12. | (b). |
Fill in the Blanks
| 1. | Decomposing, redundancy |
| 2. | Normalization |
| 3. | Normalization |
| 4. | E. F. Codd |
| 5. | Atomic |
| 6. | 1NF, fully functionally dependent |
| 7. | Composite, attribute |
| 8. | 1NF |
| 9. | Primary (or relation) key |
| 10. | X Y |
| 11. | 3NF |
| 12. | Candidate key |
| 13. | 3NF, 2NF |
| 14. | Primary, candidate, candidate |
| 15. | MVDs |
| 16. | Consequence. |
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.
