O'Reilly logo

Database Systems: Concepts, Design and Applications by S. K. Singh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 AB and BA, amongst others. Explain what such a pair of dependencies means about the relationship in the database model?
7.What is a functional dependency diagram? ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required