functional dependency theory

mcqspedia.com has 5 Question/Answers about Topic functional dependency theory

Normalization process can be done formally as part of

Normalization process can be done formally as part of
  • A. Data handling
  • B. Data processing
  • C. Data modeling
  • D. Data monitoring
  • Correct Answer: Option C

A schema is said not to be in a desirable normal form, if its relationship sets are involving

A schema is said not to be in a desirable normal form, if its relationship sets are involving
  • A. One entity set
  • B. Two entity sets
  • C. More than two entity sets
  • D. No entity sets
  • Correct Answer: Option C

Multivalued dependencies helps in eliminate of some forms of

Multivalued dependencies helps in eliminate of some forms of
  • A. Redundancy
  • B. Isolation
  • C. Atomicity
  • D. Inconsistency
  • Correct Answer: Option A

Process of creation of an E-R design tends to generate

Process of creation of an E-R design tends to generate
  • A. 2NF designs
  • B. 3NF designs
  • C. 4NF designs
  • D. 5NF designs
  • Correct Answer: Option C

Universal-relation approach of a single schema defines interactions of database along with

Universal-relation approach of a single schema defines interactions of database along with
  • A. Users
  • B. Systems
  • C. Applications
  • D. Both A and C
  • Correct Answer: Option D