Review Questions
| 1. | What do you mean by functional dependency? Explain with an example and a functional dependency diagram. |
| 2. | What is the importance of functional dependencies in database design? |
| 3. | What are the main characteristics of functional dependencies? |
| 4. | Describe Armstrong’s axioms. What are derived rules? |
| 5. | Describe how a database designer typically identifies the set of FDs associated with a relation. |
| 6. | A relation schema R (A, B, C) is given, which represents a relationship between two entity sets with primary key A and B respectively. Let us assume that R has the FDs A → B and B → A, amongst others. Explain what such a pair of dependencies means about the relationship in the database model? |
| 7. | What is a functional dependency diagram? ... |
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.
