O'Reilly logo

Database Systems: Concepts, Design and Applications by S. K. Singh

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Tick (✓) the Appropriate Answer

1.A functional dependency is a
  1. many-to-many relationship between two sets of attributes.

  2. one-to-one relationship between two sets of attributes.

  3. many-to-one relationship between two sets of attributes.

  4. none of these.

2.Decomposition helps in eliminating some of the problems of bad design such as
  1. redundancy

  2. inconsistencies

  3. anomalies

  4. all of these.

3.The word loss in lossless refers to the
  1. loss of information.

  2. loss of attributes.

  3. loss of relations.

  4. none of these.

4.The dependency preservation decomposition is a property of decomposed relational database schema D in which each functional dependency XY specified in F
  1. appeared directly in one of the relation schemas Ri in the decomposed D.

  2. could be inferred from the dependencies ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required