aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • DBMS Practice Test: Normalization and Transactions
  • Given R(A,B, C, D, E) and $ F = \\{ B \rightarrow, AB \ri...
Multiple choice

Given R(A,B, C, D, E) and $ F = \{ B \rightarrow, AB \rightarrow C, CD \rightarrow E \} \text{ and } D = \{BE, ABDE\}$be decomposition. What is the highest normal form of decomposition D?

  1. 1 NF

  2. 2 NF

  3. 3 NF

  4. BCNF

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

null

Keep practicing — related questions

  • Consider the following relation R (A, B, C, D, E, F) with FD set A$\rightarrow$BCDEF BC$\rightarrow$ADEF B$...
  • Consider a relation: R(A, B, C, D) with FD A$\rightarrow$BCD BC$\rightarrow$AD D$\rightarrow$B The highest ...
  • Normalization: which is automatic NORMAL form? (NF=normal form)
  • Which of the following statements about normal forms is FALSE?
  • ______________ normal form in database system states that the left hand side of every non-trivial function ...
  • dfdf
  • Consider the schema R = (S, T, U, V) and dependencies S$\rightarrow$T, T$\rightarrow$U, U$\rightarrow$V and...
  • R, (A, B, C, D) is a relation. Which of the following does not have a lossless join, dependency preserving ...
Play the full quiz 🎤 Practise this topic out loud
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy