aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • Test 2 - Databases | Computer Science(CS)
  • Consider a relation scheme R = (A,B,C,D,E,H) on which the...
Multiple choice

Consider a relation scheme R = (A,B,C,D,E,H) on which the following functional dependencies hold: {A $\rightarrow$ B, C $\rightarrow$ D, E $\rightarrow$ C, D $\rightarrow$ A}

What are the candidate keys of R?

  1. AE,BE

  2. AE,BE,DE

  3. AEH,BEH,BCH

  4. AEH,BEH,DEH

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Keep practicing — related questions

  • Set F of functional dependencies for relation schema R(A, B, C, D, E) is A$\rightarrow$BC, CD$\rightarrow$E...
  • Relation R has eight attributes ABCDEFGH. Fields of R contain only atomic values. F = {CH $\leftarrow$ G, A...
  • Consider the following functional dependencies: AB$\rightarrow$CD, AF $\rightarrow$ D,DE $\rightarrow$F,C $...
  • Consider the following functional dependencies: AB$\rightarrow$CD, AF $\rightarrow$ D,DE $\rightarrow$F,C $...
  • If every non-key attribute is functionally dependent on the primary key, the relation will be in
  • If every non-key attribute is functionally dependent on the primary key, the relation will be in
  • The following functional dependencies hold for relations R(A, B, C) and S(B, D, E) B $\rightarrow$A, A $\ri...
  • Consider the following relation instance. X Y Z 1 4 2 1 5 3 1 6 3 3 2 2 Which of the following functional d...
Play the full quiz 🎤 Practise this topic out loud
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy