187 views
0 votes
0 votes

Consider a relation R with attributes {A,B,C} and functional dependency set S ={A → B, A → C}. Then relation R can be decomposed into two relations: 

 

  1. R1{A,B} AND R2{A,C}
  2. R1{A,B} AND R2{B,C]
  3. R1{A,B,C} AND R2{A,C}
  4. None of the above

Please log in or register to answer this question.

Related questions

0 votes
0 votes
1 answer
1
rsansiya111 asked Dec 6, 2021
289 views
Consider the relations:$R_{1}${Roll_No, Name, Grades} and $R_{2}${Roll_No, Subject_ID, Grades}Which of the following operations cannot be performed using the above relati...
0 votes
0 votes
1 answer
2
rapidxy asked Dec 14, 2021
391 views
Let $C(n,r)= \binom{n}{r}$.The value of $\sum_{k=0}^{20}(2k+1)C(41,2k+1)$ is :A)40(2)^40 B)40(2)^39C)41(2)^40D)41(2)^39
1 votes
1 votes
0 answers
3
rsansiya111 asked Dec 6, 2021
407 views
If a hash table is implemented asa search tree, the expected time required to enter n names and make m searches is proportional to: (n + m) $log_{2} n$(n + m) $log_{2} m$...
0 votes
0 votes
1 answer
4
rsansiya111 asked Dec 6, 2021
728 views
Total number of nodes at the nth level of a full binary tree can be given as___________. 2n + 1$2n^{2}$2^n2n – 1