DBMS-Function Dependency and Decomposition Questions and Answers
DBMS-Function Dependency and Decomposition
Showing 10 of
14 questions
1. Functional dependeny allows the database designer to express facts about the enterprise that the designer is modelling with the enterprise database.
- TRUE
- FALSE
2. A functional dependency is a many-to-many relationship between two sets of attributes X and Y of a given table T.
- TRUE
- FALSE
3. The term full functional dependency (FFD) is used to indicate the maxmimum set of attributes in a determinant of a functional dependency (FD).
- TRUE
- FALSE
4. A functional dependency in the set is redundant if it can be derived from the other functional dependencies in the set.
- TRUE
- FALSE
5. A closure of a set (also called complete sets) of functional dependency defines all the FDs that can be derived from a given set of FDs.
- TRUE
- FALSE
6. A functional decomposition is the process of breaking down the functions of an organization into progressively greater (finer and finer) levels of detail.
- TRUE
- FALSE
8. The dependencies are preserved because each dependency in F represents a constraint on the database.
- TRUE
- FALSE
9. If decomposition is not dependency-preserving, some dependency is lost in the decomposition.
- TRUE
- FALSE
10. A functional dependency is a
- many-to-many relationship between two sets of attributes
- one-to-one relationship between two sets of attributes.
- many-to-one relationship between two sets of attributes
- none of these.