Database Normalization of Relations MCQ (Multiple Choice Questions) PDF Download

The property of normalization of relations which guarantees that functional dependencies are represented in separate relations after decomposition is classified as

1. nonadditive join property
2. independency reservation property
3. dependency preservation property
4. additive join property

The process of analyzing relation schemas to achieve minimal redundancy and insertion or update anomalies is classified as

1. normalization of data
2. denomination of data
3. isolation of data
4. de-normalization of data

The procedure of storing higher normal form relations which are in lower normal form as a base relation is classified as

1. isolation of data
2. de-normalization of data
3. normalization of data
4. denomination of data

In normalization of relations, the property which is critical and must be achieved is classified as

1. nonadditive join property
2. additive join property
3. independency reservation property
4. dependency preservation property

The joining property which guarantees that spurious tuple generation problem is not created after decomposition is called

1. lossless join property
2. nonadditive join property
3. additive join property
4. both a and b