aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • DBMS Practice Test: Normalization and Transactions
  • Set F of functional dependencies for relation schema R(A,...
Multiple choice

Set F of functional dependencies for relation schema R(A, B, C, D, E) is A$\rightarrow$BC, CD$\rightarrow$E, B$\rightarrow$D, E$\rightarrow$A. Determine the number of candidate's keys for R.

  1. 2

  2. 3

  3. 4

  4. 5

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

Candidate's keys are A, BC, CD, E.

Keep practicing — related questions

  • Consider a relation scheme R = (A,B,C,D,E,H) on which the following functional dependencies hold: {A $\righ...
  • Consider a relation scheme R = (A, B, C, D, E, H), on which the following functional dependencies hold: (A ...
  • Consider a relation scheme R = (A, B, C, D, E, H), on which the following functional dependencies hold: (A ...
  • Relation R has eight attributes ABCDEFGH. Fields of R contain only atomic values. F = {CH $\leftarrow$ G, A...
  • 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
  • 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
Play the full quiz 🎤 Practise this topic out loud
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy