Chapter 9 Functional Dependency and Decomposition
State True/False
| 1. | True |
| 2. | True |
| 3. | False |
| 4. | False |
| 5. | True |
| 6. | True |
| 7. | True |
| 8. | False |
| 9. | True |
| 10. | True |
Tick (✓) the Appropriate Answer
| 1. | (c) |
| 2. | (d) |
| 3. | (a) |
| 4. | (c) |
| 5. | (c) |
Fill in the Blanks
| 1. | Functional dependency, attributes |
| 2. | (a) determinant, (b) dependent |
| 3. | Functionally determines |
| 4. | Minimum, determinant |
| 5. | Functional dependencies |
| 6. | FDs, FDs |
| 7. | Breaking down |
| 8. | Spurious tuples, natural join |
| 9. | Loss of information |
| 10. | Non-redundant set and complete sets (or closure) of. |
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.
