Register

DBMS coalescence rule

• retagged by
396 views

1 Answer

1 votes
1 votes
$if X \twoheadrightarrow Y$ and there exists W with the property that

$1. W\cap Y=\varnothing $

$2. W\rightarrow Z$

$3. Z\subseteq Y$

then $ X\rightarrow Z$
User Avatar
Voting & Accepting an answer helps improve the community
← PreviousNext →
← Previous in categoryNext in category →

Related questions

0 votes
0 votes
1 answer
1
anupamsworld asked Jul 26, 2022
257 views
Class Practice Question | Thomas Write Rule | Basic Time Stamp | Unacademy
Which of the following time stamp ordering protocol(s) allow(s) the following schedule? S: W1(A), W2(A), W3(A), R2(A), R4(A); Time Stamps: T1:5, T2:10, T3:15, T4:20 Tomas Write Rule Basic Time Stamp Only 1 Only 2 Both 1 and 2 Neither 1 nor 2 Please describe your answer.
Which of the following time stamp ordering protocol(s) allow(s) the following schedule?S: W1(A), W2(A), W3(A), R2(A), R4(A);Time Stamps: T1:5, T2:10, T3:15, T4:20Tomas Wr...
User Avatar
1 votes
1 votes
0 answers
2
Karishma Datt asked Jul 24, 2022
414 views
Thomas write rule
Need some help , In this question W3(B) , W2(B) is allowed in TWR bit confuse between option b and d . Plz help me which option is correct between b and d with proper justification.
Need some help , In this question W3(B) , W2(B) is allowed in TWR bit confuse between option b and d . Plz help me which option is correct between b and d with proper jus...
User Avatar
0 votes
0 votes
0 answers
3
Fida asked Dec 27, 2018
246 views
What if the production rule does not have the attribute present in relation
If a relation is having (A,B,C,D) And product rules A->b B->c ..... Then A be candidate key or we have to include D too I AD ..…
If a relation is having (A,B,C,D)And product rulesA->bB->c..... Then A be candidate key or we have to include D too I AD ..…
User Avatar
1 votes
1 votes
1 answer
4
aditi19 asked Dec 1, 2018
1,931 views
Thomas write rule doubt
there is a schedule which is allowed in Thomas write rule so it is view serializable. Suppose at a point write operation of an older transaction is ignored. then the same operation will be ignored in its serial order?
there is a schedule which is allowed in Thomas write rule so it is view serializable. Suppose at a point write operation of an older transaction is ignored. then the same...
User Avatar
Link Copied!