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 data analytics technique is suitable for handling missing data points in a dataset?
The dynamic memory allocation is the memory allocation done at the _________.
Which of these can be overloaded?
Which of the following is a valid token in lexical analysis?
What does a "Shared Lock" in a DBMS locking protocol allow?
Â
Consider a 4-way set associative cache consisting of 128 lines with a line size of 64 words. The CPU generates a 20-bit address of a word in main memor...
In dynamic programming, what is memoization?
What is the minimum no. of variables/ features required to perform clustering?
What is the basic component of an electronic circuit that restricts the flow of current?
When designing a sequential circuit, what is the purpose of flip-flops or latches?
