Loading, please wait ...
Open its course - Database Systems

Fill in Blanks Questions for Functional Dependencies (FDs)

  • 1 Inference rules called _____Armstrong’s axioms_ can be used to identify a minimal set of functional dependencies from the set of all functional dependencies for a relation. View Answer

  • 2 Inference rules can be used to identify the set of all _____functional dependencies associated with a relation. This set can be very large for a given relation. View Answer

  • 3 One characteristic of functional dependency is a _____one-to-_____one_ relationship between the attribute(s) on the left-hand side (determinant) and those on the right-hand side of a functional dependency View Answer

  • 4 To find _____Functional Dependency it is important to distinguish clearly between the values held by an attribute at a given point in time and the set of all possible values that an attribute may hold at different times. View Answer

  • 5 _____Full Functional Dependency indicates that if A and B are attributes of a relation, B is fully functionally dependent on A if B is functionally dependent on A, but not on any subset of A. View Answer

  • 6 _____Determinant refers to the attribute, or group of attributes, on the left-hand side of the arrow of a functional dependency. View Answer

  • 7 A --> B is a _____partial dependency if there is some attribute that can be removed from A and yet the dependency still holds. View Answer

Contact Us

Write to Us View Help
Subject Expert Logo

Subject Expert

Learn, Evaluate and Optimize

Follow Us
Facebook Switch Display Mode Enable Translation
© 2024 - Subject Expert