Database Systems: Concepts, Design and Applications

Tick (✓) the Appropriate Answer

1.	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.
2.	Decomposition helps in eliminating some of the problems of bad design such as redundancy inconsistencies anomalies all of these.
3.	The word loss in lossless refers to the loss of information. loss of attributes. loss of relations. none of these.
4.	The dependency preservation decomposition is a property of decomposed relational database schema D in which each functional dependency X →Y specified in F appeared directly in one of the relation schemas Ri in the decomposed D. could be inferred from the dependencies ...