Question
relation R(ABCD) has these dependencies {A → B, B →
C,C → D} and it is decomposed into three relations R1(AB) , R2(BC), AND R3(CD). State true or false if the decomposition is dependency preserving or not?Solution
The decomposition is dependency preserving. Because the union of all the functional dependencies from R1, R2 AND R3 is equal to the dependencies that are in relation R.
Which of the following code for ‘rocking’?
In a certain code language, ‘SAPLING’ is coded as '14' and ‘CHEMIST’ is coded as '152'. What is the code of word ‘MANLY’ in the same coding ...
- In a certain code language, 'SUMMON' is written as '42' and 'MORE' is written as '24'. How will 'RURAL' be written in that language?
In a certain code language ‘MARVEL’ is written as ‘QALKEU’ and ‘SOONER’ is written as ‘NORQEM’. How is ‘PRAISE’ written in that code...
In a certain code language, TAMARIND is written as SCLCQKMC. How will WIRELESS be coded in that language?
In a code language, 561 means ‘previous letters arranged’, 501 means ‘previous letters compiled, 063 ‘compiled alphabets arranged’. Find the c...
In a certain code language, ‘CHAIRS’ is written as 'XIXRSP' and ‘SOUNDS’ is written as 'HPRMEP'. How will ‘DEFINE’ be written in that language?
In a certain code language, ‘PLATFORM’ is coded as ‘OTQHVCNR’ and ‘DEMAND’ is written as ‘FPCOG’. How will ‘VANISH’ be written in th...
What is the code for “its first space” in the given code language?
Who among the following person attends the class on 7th March?
