functional dependencies and normalization

MCQsQuestion.com has 5 Question/Answers about Topic functional dependencies and normalization

Rule which states that addition of same attributes to right side and left side will results in other valid dependency is classified as

Rule which states that addition of same attributes to right side and left side will results in other valid dependency is classified as
  • A. referential rule
  • B. inferential rule
  • C. augmentation rule
  • D. reflexive rule
  • Correct Answer: Option C

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

Procedure of storing higher normal form relations which are in lower normal form as a base relation is classified as
  • A. isolation of data
  • B. de-normalization of data
  • C. normalization of data
  • D. denomination of data
  • Correct Answer: Option B

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

In normalization of relations, property which is critical and must be achieved is classified as
  • A. nonadditive join property
  • B. additive join property
  • C. independency reservation property
  • D. dependency preservation property
  • Correct Answer: Option A

Normalization form which is based on transitive dependency is classified as

Normalization form which is based on transitive dependency is classified as
  • A. first normal form
  • B. second normal form
  • C. fourth normal form
  • D. third normal form
  • Correct Answer: Option D

Rule which states that set of attributes determines any of its subset is classified as

Rule which states that set of attributes determines any of its subset is classified as
  • A. closure rule
  • B. reflexive rule
  • C. referential rule
  • D. inferential rule
  • Correct Answer: Option B