Login
Register
Dark Mode
Brightness
Profile
Edit Profile
Messages
My favorites
My Updates
Logout
Search results for lossless-join
2
votes
1
answer
1
NIELIT 2022 April Scientist B | Section B | Question: 49
Let $\text{R (A, B, C, D)}$ be a relational schema with the following functional dependencies: $\text{A} \rightarrow \text{B, B} \rightarrow \text{C}$ $\text{C} \rightarrow \text{D}$ ... dependency preserving does not give a lossless join, but is dependency preserving does not give a lossless join and is not dependency preserving
Let $\text{R (A, B, C, D)}$ be a relational schema with the following functional dependencies: $\text{A} \rightarrow \text{B, B} \rightarrow \text{C}$ $\text{C} \rightar...
soujanyareddy13
939
views
soujanyareddy13
asked
Apr 12, 2022
Others
nielit2022apr-scientistb
databases
database-normalization
lossless-join
+
–
2
votes
2
answers
2
Self doubt dbms Normalisation
Is minimal set of functional dependency for a functional dependency set is always unique???
Is minimal set of functional dependency for a functional dependency set is always unique???
gatecrack
582
views
gatecrack
asked
Dec 10, 2018
Databases
databases
decomposition
lossless-join
database-normalization
+
–
4
votes
2
answers
3
cil-2017 Q87
VS
412
views
VS
asked
Apr 9, 2017
Databases
cil-2017
databases
lossless-join
database-normalization
+
–
1
votes
1
answer
4
Lossless join
Mk Utkarsh
983
views
Mk Utkarsh
asked
Jan 12, 2018
Databases
databases
decomposition
lossless-join
+
–
3
votes
1
answer
5
Gateforum Test series
Mk Utkarsh
458
views
Mk Utkarsh
asked
Jan 12, 2018
Databases
gateforum-test-series
lossless-join
dependency-preserving
+
–
1
votes
2
answers
6
lossless join
$R(X,Y,Z,W) is\ decomposed\ into \\ R_1(X,Y)\\ R_2(Y,Z)\\ R_3(Y,W).\\The\ FDs\ are\ :\\ X -> Y,\\ Z->Y,\\ Y->W \\ Find\ whether\ the\ decomposition\ is\ lossless\ or\ lossy\ ?$
$R(X,Y,Z,W) is\ decomposed\ into \\ R_1(X,Y)\\ R_2(Y,Z)\\ R_3(Y,W).\\The\ FDs\ are\ :\\ X - Y,\\ Z->Y,\\ Y->W \\ Find\ whether\ the\ decomposition\ is\ lossless\ or\ ...
Tuhin Dutta
596
views
Tuhin Dutta
asked
Dec 8, 2017
Databases
databases
decomposition
lossless-join
+
–
2
votes
1
answer
7
Gateforum DBMS
Mk Utkarsh
1.4k
views
Mk Utkarsh
asked
Jan 12, 2018
Databases
gateforum-test-series
databases
lossless-join
bcnf-decomposition
+
–
4
votes
1
answer
8
Test by Bikram | Mock GATE | Test 4 | Question: 10
Consider the relation $R(X\;Y\;W\;M\;E\;G),$ with $FD$ set $\{XY \rightarrow W, E \rightarrow G, XW \rightarrow Y, YW \rightarrow X, Y \rightarrow M, XM \rightarrow E \}.$ Following are two decompositions ... are lossless-join decompositions. Both $P_1$ and $P_2$ are lossless-join decompositions. $P_1$ is lossless-join decomposition but not $P_2$.
Consider the relation $R(X\;Y\;W\;M\;E\;G),$with $FD$ set $\{XY \rightarrow W, E \rightarrow G, XW \rightarrow Y, YW \rightarrow X, Y \rightarrow M, XM \rightarrow E \}....
Bikram
682
views
Bikram
asked
May 14, 2017
Databases
tbb-mockgate-4
databases
database-normalization
lossless-decomposition
lossless-join
+
–
0
votes
0
answers
9
DBMS Losless join
R is divided into R1 and R2 ,but since there is no common attribute in R1 and R2, so it should form lossy join,as for loseless join the common attribute has to be key in one of the table.But here the image above,it is comming as loseless join.Can someone please check?
R is divided into R1 and R2 ,but since there is no common attribute in R1 and R2, so it should form lossy join,as for loseless join the common attribute has to be key in ...
rahul sharma 5
470
views
rahul sharma 5
asked
Dec 12, 2017
Databases
databases
natural-join
decomposition
lossless-join
+
–
3
votes
4
answers
10
DBMS-Normalisation-Lossless Join Decomposition
KISHALAY DAS
1.1k
views
KISHALAY DAS
asked
Dec 21, 2016
Databases
databases
decomposition
database-normalization
lossless-join
+
–
0
votes
1
answer
11
Testing Lossless join
State true or false:- Symbol " ^ " stands for an intersection AND letters in bold are the candidate key of the respective table. 1) R1(A, B, C) ^ R2(B, C) = {B,C} IS LOSSLESS JOIN. 2) R1(A, B, C) ^ R2(B, D) = {B} IS LOSSY JOIN. 3) R1(A, B ... C), R2(D, E), R3(F, B), R4(D, G, A) Also, tell what will be the candidate key after performing join each time and at the end.
State true or false:-Symbol " ^ " stands for an intersection AND letters in bold are the candidate key of the respective table.1) R1(A, B, C) ^ R2(B, C) = {B,C} IS LOSSL...
Shubhanshu
628
views
Shubhanshu
asked
May 3, 2017
Databases
databases
decomposition
lossless-join
+
–
0
votes
1
answer
12
Lossless or Lossy (Explain with help of table drawing, if possible)
R(ABCDEG) and FD sets {AB->C, AC->B, AD->E, B->D, BC->A, E->G} D=( ABC, ACDE, ADG)
R(ABCDEG) and FD sets {AB->C, AC->B, AD->E, B->D, BC->A, E->G} D=( ABC, ACDE, ADG)
smartmeet
301
views
smartmeet
asked
Jan 27, 2017
Databases
databases
lossless-join
+
–
0
votes
1
answer
13
Database mgmt system
Tell whether the following decomposition of relations lossless and dependency preserving or not. 1. R(ABCDEFGHIJ) and FD sets AB->C, A->DE, B->F, F->GH, D->IJ a) D1"={ DIJ, ACE, FGH, BF, ADC} b) D2={ FGH, DIJ, ADEBF, ABC} 2.R(ABCDEG) and FD sets AB->C, AC->B, AD->E, B->D, BC->A, E->G a) D=( ABC, ACDE, ADG)
Tell whether the following decomposition of relations lossless and dependency preserving or not.1. R(ABCDEFGHIJ) and FD setsAB->C, A->DE, B->F, F->GH, D->IJa) D1"={ DI...
Chetnawadhwa
1.5k
views
Chetnawadhwa
asked
Nov 2, 2016
Databases
databases
lossless-join
dependency-preserving
database-normalization
decomposition
+
–
0
votes
1
answer
14
self_doubt
If a relation is decomposed into more than two relations then what is the correct method to check whether the decomposition is lossless or not? Can we use R1⋂R2→R1 or R1⋂R2→R2 pairwise for the decomposition or is there any other method?
If a relation is decomposed into more than two relations then what is the correct method to check whether the decomposition is lossless or not? Can we use R1⋂R2→R1 or...
Akhilesh Yadav 1
239
views
Akhilesh Yadav 1
asked
Dec 30, 2016
Databases
lossless-join
+
–
4
votes
1
answer
15
Checking for lossless-join property
The decomposition of relation R with FD set F into R1 and R2 has lossless join property iff R1 $\cap$ R2 $\rightarrow$ R1 $\in$ F$^+$ OR R1 $\cap$ R2 $\rightarrow$ R2 $\in$ F$^+$ If R is decomposed into more than 2 ... ? Or is that table drawing thing the only way to check for lossless join property ? Answers with reference(s) will be much appreciated. Thanks.
The decomposition of relation R with FD set F into R1 and R2 has lossless join property iffR1 $\cap$ R2 $\rightarrow$ R1 $\in$ F$^+$ ORR1 $\cap$ R2 $\rightarrow$ R2 $\in...
Rounak Agarwal
1.0k
views
Rounak Agarwal
asked
Sep 22, 2016
Databases
decomposition
databases
lossless-join
+
–
To see more, click for the
full list of questions
or
popular tags
.
Email or Username
Show
Hide
Password
I forgot my password
Remember
Log in
Register