DBMS-Function Dependency and Decomposition
DBMS-Function Dependency and Decomposition
11. Decomposition helps in eliminating some of the problems of bad design such as
- redundancy
- inconsistencies
- anomalies
- all of these
12. The word loss in lossless refers to the
- loss of information.
- loss of attributes
- loss of relations
- none of these.
13. The dependency preservation decomposition is a property of decomposed relational database schema D in which each functional dependency D----->Y specified in F
- appeared directly in one of the relation schemas R1 in the deomposed D.
- could be inferred from dependencies that appear in some Ri.
- both (a) and (b)
- none of these.
14. The set of attributes X will be fully functionally dependent on the set of attributes Y if the following conditions are satisfied:
- X is functionally dependent on Y.
- X is not functionally dependent on any subset of Y.
- both (a) and (b)
- none of these