aliensbrain
  • Home
  • Study
  • Quizzes
  • 🎤AI Practicefree
  • Notebooks
  • Community
  • Sign in
  • DBMS Practice Test: Normalization and Transactions
  • Consider the schema R = (S, T, U, V) and dependencies S$\...
Multiple choice

Consider the schema R = (S, T, U, V) and dependencies S$\rightarrow$T, T$\rightarrow$U, U$\rightarrow$V and V$\rightarrow$S. Let R$R = \{ R_1 \text{ and } R_2 \}$be a decomposition such that $R_1 \cap R_2 = \phi$. The decomposition is

  1. not in 2NF

  2. in 2NF but not in 3NF

  3. in 3NF but not in 2NF

  4. in both 2NF and 3NF

Reveal answer Fill a bubble to check yourself
D Correct answer

Keep practicing — related questions

  • Consider a schema R(A,B,C,D) and functional dependencies A$\rightarrow$ B and C$\rightarrow$ D. Then the de...
  • Relation R is decomposed using a set of functional dependencies F and relation S is decomposed using anothe...
  • Relation R with an associated set of functional dependencies, F is decomposed in to BCNF. The redundancy in...
  • A relational schema in BCNF(3.5 NF) can still have which of the following dependencies?
  • Consider the following relational schema: Suppliers(sid:integer, sname:string, city:string, street:string) ...
  • Consider the following relational schema: Suppliers(sid:integer, sname:string, city:string, street:string) ...
  • 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 $\rightarrow$ G, ...
Play the full quiz 🎤 Practise this topic out loud
Advertisement
© Aliensbrain | all rights reserved
  • About
  • Contact
  • Terms and Condition
  • Privacy Policy