August 2009
Intermediate to advanced
893 pages
26h 48m
English
Content preview from Database Systems: Concepts, Design and Applications
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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? ... |