Recent questions tagged lossless-decomposition

Consider $R(A,B,C,D,E,F,G,H)$ with $F=\{AB\to CD,\ AC\to DE,\ EF\to AG\}$.The decomposition is $R_1(A,C,D,E),$ $R_2(A,B,C),$ $R_3(A,B,F,G,H)$.Which statement correctly de...

Consider $R(A,B,C,D,E,F,G)$ with $F=\{AC\to BD,\ BC\to E,\ BE\to DF,\ AG\to EB\}$ and decomposition $R_1(A,B,C,D),$ $R_2(A,B,C,E,G),$ $R_3(B,E,F),$ $R_4(A,E,G)$.Which of ...

Consider $R(A,B,C,D,E,F)$ with $F=\{C\to D,\ A\to B,\ B\to EF,\ F\to A\}$.Suppose $R$ is decomposed into $R_1(A,B,D,E)$ and $R_2(A,B,C,F)$. The decomposition is currently...

Consider a schema $\text{R(P, Q, R, S)}$ and the following functional dependencies $\text{P} \rightarrow \text{Q}, \text{Q} \rightarrow \text{R}, \text{R} \rightarrow \te...

There is a schema as follows : loan(custname, branch, loanno, amount) with following Functiona dependencies : 1. custname - loanno.2.loanno. - amountbased on this the sch...

The lecturer gives a set of funcional dependencies and the task is to get the canonical form.The dependencies are as follows. 1.B->C2.A->B and 3.AB->Cas proof for fd fd ...

Consider a relation $R\left ( A,B,C,D,E \right )$ and functional dependencies are $F=\left \{ AC\rightarrow B,C\rightarrow D,A\rightarrow E,C\rightarrow B \right \}$Relat...

is option B correct?in ii) intersection of the two normalized relation is EF which is not key of either of the relationshow can option B be correct?

Given $R(A,B,C,D,E)$ and $F:\left \{A\rightarrow BC ,CD\rightarrow E,B\rightarrow D,E\rightarrow A\right \}$,Decompose into $BCNF?$$(a)$Every $BCNF$ is $3NF$ and vice ver...

The below decomposition is lossless or lossy and also dependency preserving or not?

Relation: R(ABCDE):FDs: A->BC, CD->E, B->D, E->AThis relation is not in BCNF bcz of FD B->D. So how it make BCNF by decomposition so that the resultant decomposition is b...