Database - Normalization for Relational Databases

Avatto>>UGC NET COMPUTER SCIENCE>>PRACTICE QUESTIONS>>Database>>Normalization for Relational Databases

6. Consider the following set of functional dependencies on the schema (A, B, C)
A --> BC,
B —> C,
A —> B,
AB —> C
The canonical cover for this set is

  • Option : A
  • Explanation : Sets of functional dependencies may have redundant dependencies that can be inferred from the other functional dependencies.
    A canonical cover of F is a “minimal” set of functional dependencies equivalent to F, having no redundant dependencies or redundant parts of dependencies.
    As we can infer all FD's from option A, so A is the right answer.
Cancel reply
Cancel reply

  • Normalisation in DBMS Questions can be used by any candidate who is preparing for UGC NET Computer Science
  • This Normalisation  MCQ section will help you test your analytical skills in a tricky method, thereby giving you an edge over other students
  • Any student who wants to prepare for DOEACC A Level, DOEACC B Level, and DOEACC C level can also use these Objective Type Questions Answer.
  • All candidates who have to appear for the Kendriya Vidyalaya Entrance exam can also refer to this Normalisation quiz questions with answers
  • You can also get access to the Normalisation in DBMS MCQ ebook.
  • Normalisation  Questions can be used in the preparation of JRF, CSIR, and various other exams.
  • You can also download pdf for this Normalisation  multiple-choice questions Answers.
  • This Normalisation in ai Multiple Choice Questions Answers section can also be used for the preparation of various competitive exams like UGC NET, GATE, PSU, IES, and many more.
  • Normalisation Objective Type Questions Answer can be used to gain a credit score in various undergraduate and postgraduate courses like BSc, MSc and MCA

Normalisation Questions

Normalisation in DBMS  Multiple choice questions

Normalisation quiz questions with answers

Normalisation exam questions answers

Normalisation MCQ questions Answers

Normalisation in DBMS MCQ

Normalisation MCQ Pdf

Normalisation MCQ for UGC NET CS

Normalisation Multiple Choice Questions For Competitive Exams