Functional Dependencies (FDs)

  • Types of Functional Dependencies
  • Full Functional Dependency
  • Characteristics of Functional...
    View Complete Description
    ×

    Topic Summary

    • Types of Functional Dependencies
    • Full Functional Dependency
    • Characteristics of Functional Dependency
    • Identifying Functional Dependencies
    • Identifying the Primary Key for a Relation using FDs
18
Questions
Question Type Legends

Easy

Medium

Difficult

Multiple Choice Questions for Functional Dependencies (FDs)

  • 1 If A, B and C are attributes in a relation, and A is a primary key, then what type of the dependency is this if B dependent on A as well as C dependent on A?
    1. Full functional dependency
    2. Partial dependency
    3. Transitive dependency
    4. None of above

  • 2 In dependency structure, A -> B represents:
    1. B determines A
    2. A functionally dependent on B
    3. B functionally dependent on A
    4. None of above

  • 3 The attribute, or group of attributes, on the left-hand side of the arrow of a functional dependency is called:
    1. Dependent
    2. Determinant
    3. Left side Constraint
    4. Primary Key

  • 4 Which of the following is not a characteristic of the functional dependency?
    1. One to one relationship
    2. Hold for all time
    3. Maximum number of attributes
    4. Minimal number of attributes

Contact Us

support@subexpert.com
Write to Us View Help
Subject Expert Logo

Subject Expert

Learn and Evaluate

Follow Us
© 2020 - Subject Expert