559 views

5 Answers

1 1 vote
D. a-iv, b-iii, c-i, d-ii

Decomposition rule: If $x->y z$ then $x->y, x->z$

Union rule: If $x->y, x->z$ then $x->y z$

Composition rule: if $x->y$ and $z->w$ then $x z->y w$

Pseudo transitivity rule : If $\mathrm{x}->\mathrm{y}$ and $\mathrm{yw}->\mathrm{z}$ then $\mathrm{xw}->\mathrm{z}[\mathrm{y}$ replace by x$]$.
X $\rightarrow$ Zhen
• reshown by
Answer:
Position:
Show:

Related questions

3 3 votes
7 7 answers
778
778 views
GO Classes asked Jul 16, 2025
778 views
Let $R=A B C D E$ is a relational scheme with functional dependency set $F=\{A \rightarrow B, B \rightarrow C, A C \rightarrow D\}$. The attribute closures of $A$ and $E$...
2 2 votes
4 4 answers
608
608 views
GO Classes asked Jul 16, 2025
608 views
Suppose R is a relation schema and F is a set of functional dependencies on R. Further, suppose R1 and R 2 form a decomposition of R . Then the decomposition is a lossles...
1 1 vote
3 3 answers
509
509 views
GO Classes asked Jul 16, 2025
509 views
Which of the following is true?A relation in BCNF is always in $3NF$A relation in $3NF$ is always in BCNFBCNF and $3 N F$ are sameA relation in BCNF is not in $3NF$
5 5 votes
4 4 answers
815
815 views
GO Classes asked Jul 16, 2025
815 views
Which of the following is aggregate function in SQL?AvgSelectOrdered bydistinct