dependencies and normal forms

mcqspedia.com has 4 Question/Answers about Topic dependencies and normal forms

Conclusion of template is a condition which must be held on tuples hypothesis in template dependency called

Conclusion of template is a condition which must be held on tuples hypothesis in template dependency called
  • A. schema generating templates
  • B. relation filtering template
  • C. constraint generating templates
  • D. tuple generating templates
  • Correct Answer: Option C

Types of template dependencies are

Types of template dependencies are
  • A. constraint generating templates
  • B. tuple generating templates
  • C. schema generating templates
  • D. both a and b
  • Correct Answer: Option D

Template conclusion is a set of tuples that must be included in relations in template dependency called

Template conclusion is a set of tuples that must be included in relations in template dependency called
  • A. constraint generating templates
  • B. tuple generating templates
  • C. schema generating templates
  • D. relation filtering template
  • Correct Answer: Option B

Normal form which consider all types of constraints and dependencies is classified as

Normal form which consider all types of constraints and dependencies is classified as
  • A. domain-key normal form
  • B. foreign-key normal form
  • C. candidate-key normal form
  • D. primary-key normal form
  • Correct Answer: Option A