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-decomposition
2
votes
1
answer
1
GO Classes 2023 | IIITH Mock Test 1 | Question: 46
Consider a relation schema $\mathrm{R}$ with attributes $(\mathrm{X}, \mathrm{Y}, \mathrm{Z}, \mathrm{U}, \mathrm{V}, \mathrm{W})$ and the functional dependency set $\mathrm{F}$ that holds on $\mathrm{R}:$ ... . Decomposition is dependency preserving. $\text{P}$ is in $3 \mathrm{NF}$. $\mathrm{S}$ is in $3 \mathrm{NF}$.
GO Classes
asked
in
Databases
Mar 26, 2023
by
GO Classes
641
views
goclasses2023-iiith-mock-1
goclasses
databases
database-normalization
lossless-decomposition
dependency-preserving
multiple-selects
1-mark
6
votes
5
answers
2
Made Easy Test Series:DBMS-Functional Dependency
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 \}$ Relation $R$ ... Then Is it a lossless decomposition? I am getting doubt, how it can be not lossless decomposition?
srestha
asked
in
Databases
Apr 28, 2019
by
srestha
1.4k
views
database-normalization
databases
lossless-decomposition
1
vote
1
answer
3
made easy test series - lossless join and dependency preserving
How is A answer?
amitqy
asked
in
Databases
Apr 7, 2019
by
amitqy
984
views
lossless-decomposition
databases
dependency-preserving
database-normalization
0
votes
0
answers
4
dependency preservation
Consider a relation R= {M, N, O,P, Q, R, S, T} with the following set of dependencies: MN -> Q M -> RQ N -> R R -> ST Next consider the following set of decompositions for the relation schema R: D1= {R1,R2,R3,R4}: R1={M,N,O,P} ... ,T} Which of the above decomposition (1) has/ have lossless join property? A. Only D1 B. Only D2 C.Both D1 and D2 D. Neither D1 nor D2
OneZero
asked
in
Databases
Dec 19, 2018
by
OneZero
512
views
databases
dependency-preserving
lossless-decomposition
2
votes
1
answer
5
GA_Testseries
is option B correct? in ii) intersection of the two normalized relation is EF which is not key of either of the relations how can option B be correct?
aditi19
asked
in
Databases
Dec 10, 2018
by
aditi19
670
views
database-normalization
lossless-decomposition
databases
1
vote
1
answer
6
Functional preserving
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 versa $?$ $(b)FD$ preserving or not$?$ $(c)$ Lossless decomposition or lossy decomposition?
Lakshman Bhaiya
asked
in
Databases
Nov 20, 2018
by
Lakshman Bhaiya
2.0k
views
databases
database-normalization
dependency-preserving
lossless-decomposition
6
votes
2
answers
7
Lossless Decomposition and Dependency Preservation
Consider R(A,B,C,D,E)with the FD Set F(A->B, A->C, DE->C, DE->B, C->D) Consider this decomposition : R1(A,B,C), R2(B,C,D,E) and R3(A,E) Then, the decompositions is Lossless Decomposition Dependency Preserving Which of the ... 1 is TRUE but 2 is FALSE B) 1 is FALSE but 2 is TRUE C) Both 1 and 2 are TRUE D) Both 1 and 2 are FALSE
Balaji Jegan
asked
in
Databases
Sep 26, 2018
by
Balaji Jegan
2.2k
views
dependency-preserving
databases
lossless-decomposition
database-normalization
0
votes
1
answer
8
lossless and dependency preserving decomposition #testseries
The below decomposition is lossless or lossy and also dependency preserving or not?
night_fury
asked
in
Databases
Sep 23, 2018
by
night_fury
729
views
dependency-preserving
lossless-decomposition
2
votes
2
answers
9
Lossless decomposition
Relation: R(ABCDE): FDs: A->BC, CD->E, B->D, E->A This relation is not in BCNF bcz of FD B->D. So how it make BCNF by decomposition so that the resultant decomposition is both lossless and dependency preserving ? plzz explain ?
rishu_darkshadow
asked
in
Databases
Sep 20, 2017
by
rishu_darkshadow
3.4k
views
lossless-decomposition
bcnf-decomposition
4
votes
1
answer
10
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
677
views
tbb-mockgate-4
databases
database-normalization
lossless-decomposition
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-decomposition
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:...