Login
Register
@
Dark Mode
Profile
Edit my Profile
Messages
My favorites
Register
Activity
Q&A
Questions
Unanswered
Tags
Subjects
Users
Ask
Previous Years
Blogs
New Blog
Exams
Dark Mode
Recent questions tagged 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
soujanyareddy13
asked
in
Others
Apr 12, 2022
by
soujanyareddy13
940
views
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???
gatecrack
asked
in
Databases
Dec 10, 2018
by
gatecrack
604
views
databases
decomposition
lossless-join
database-normalization
3
votes
1
answer
3
Gateforum Test series
Mk Utkarsh
asked
in
Databases
Jan 12, 2018
by
Mk Utkarsh
469
views
gateforum-test-series
lossless-join
dependency-preserving
2
votes
1
answer
4
Gateforum DBMS
Mk Utkarsh
asked
in
Databases
Jan 12, 2018
by
Mk Utkarsh
1.5k
views
gateforum-test-series
databases
lossless-join
bcnf-decomposition
1
vote
1
answer
5
Lossless join
Mk Utkarsh
asked
in
Databases
Jan 12, 2018
by
Mk Utkarsh
1.0k
views
databases
decomposition
lossless-join
0
votes
0
answers
6
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?
rahul sharma 5
asked
in
Databases
Dec 12, 2017
by
rahul sharma 5
476
views
databases
natural-join
decomposition
lossless-join
1
vote
2
answers
7
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\ ?$
Tuhin Dutta
asked
in
Databases
Dec 8, 2017
by
Tuhin Dutta
612
views
databases
decomposition
lossless-join
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$.
Bikram
asked
in
Databases
May 14, 2017
by
Bikram
721
views
tbb-mockgate-4
databases
database-normalization
lossless-decomposition
lossless-join
0
votes
1
answer
9
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.
Shubhanshu
asked
in
Databases
May 3, 2017
by
Shubhanshu
638
views
databases
decomposition
lossless-join
4
votes
2
answers
10
cil-2017 Q87
VS
asked
in
Databases
Apr 9, 2017
by
VS
414
views
cil-2017
databases
lossless-join
database-normalization
0
votes
1
answer
11
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)
smartmeet
asked
in
Databases
Jan 27, 2017
by
smartmeet
303
views
databases
lossless-join
0
votes
1
answer
12
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?
Akhilesh Yadav 1
asked
in
Databases
Dec 30, 2016
by
Akhilesh Yadav 1
244
views
lossless-join
3
votes
4
answers
13
DBMS-Normalisation-Lossless Join Decomposition
KISHALAY DAS
asked
in
Databases
Dec 21, 2016
by
KISHALAY DAS
1.2k
views
databases
decomposition
database-normalization
lossless-join
0
votes
1
answer
14
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)
Chetnawadhwa
asked
in
Databases
Nov 2, 2016
by
Chetnawadhwa
1.5k
views
databases
lossless-join
dependency-preserving
database-normalization
decomposition
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.
Rounak Agarwal
asked
in
Databases
Sep 22, 2016
by
Rounak Agarwal
1.0k
views
decomposition
databases
lossless-join
To see more, click for the
full list of questions
or
popular tags
.
Subscribe to GATE CSE 2024 Test Series
Subscribe to GO Classes for GATE CSE 2024
Quick search syntax
tags
tag:apple
author
user:martin
title
title:apple
content
content:apple
exclude
-tag:apple
force match
+apple
views
views:100
score
score:10
answers
answers:2
is accepted
isaccepted:true
is closed
isclosed:true
Recent Posts
Post GATE 2024 Guidance [Counseling tips and resources]
GATE CSE 2024 Result Responses
[Project Contest] Pytorch backend support for MLCommons Cpp Inference implementation
Participating in MLCommons Inference v4.0 submission (deadline is February 23 12pm IST)
IIITH PGEE 2024 Test Series by GO Classes
Subjects
All categories
General Aptitude
(3.5k)
Engineering Mathematics
(10.4k)
Digital Logic
(3.6k)
Programming and DS
(6.2k)
Algorithms
(4.8k)
Theory of Computation
(6.9k)
Compiler Design
(2.5k)
Operating System
(5.2k)
Databases
(4.8k)
CO and Architecture
(4.0k)
Computer Networks
(4.9k)
Artificial Intelligence
(79)
Machine Learning
(48)
Data Mining and Warehousing
(25)
Non GATE
(1.4k)
Others
(2.7k)
Admissions
(684)
Exam Queries
(1.6k)
Tier 1 Placement Questions
(17)
Job Queries
(80)
Projects
(11)
Unknown Category
(870)
64.3k
questions
77.9k
answers
244k
comments
80.0k
users
Recent questions tagged lossless-join
Recent Blog Comments
category ?
Hi @Arjun sir, I have obtained a score of 591 in ...
download here
Can you please tell about IIT-H mtech CSE self...
Please add your admission queries here:...