DBMS-Function Dependency and Decomposition
DBMS-Function Dependency and Decomposition
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.