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.Normalization is a process of
  1. decomposing a set of relations.

  2. successive reduction of relation schema.

  3. deciding which attributes in a relation to be groped together.

  4. all of these.

2.The normalization process was developed by
  1. E.F. Codd.

  2. R.F. Boyce.

  3. R. Fagin.

  4. Collin White.

3.A normal form is
  1. a state of a relation that results from applying simple rules regarding FDs.

  2. the highest normal form condition that it meets.

  3. an indication of the degree to which it has been normalised.

  4. all of these.

4.Which of the following is the formal process of deciding which attributes should be grouped together in a relation?
  1. optimization

  2. normalization

  3. tuning

  4. none of these.

5.In 1NF,
  1. all domains are simple.

  2. in a simple domain, all elements are ...

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