UGC NET CS 2016 Aug- paper-3
October 19, 2023
Computer-Networks
October 19, 2023
UGC NET CS 2016 Aug- paper-3
October 19, 2023
Computer-Networks
October 19, 2023

UGC NET CS 2016 Aug- paper-3

Question 8
The Global conceptual Schema in a distributed database contains information about global relations. The condition that all the data of the global relation must be mapped into the fragments, that is, it must not happen that a data item which belongs to a global relation does not belong to any fragment, is called:
A
Disjointness condition
B
Completeness condition
C
Reconstruction condition
D
Aggregation condition
Question 8 Explanation: 
Functional Completeness Condition: It is the condition used to check the equivalence(The condition that all the data of the global relation must be mapped into the fragments) between global relation and its fragments after decomposition. When a relation is decomposed into fragments, both global relation and its fragments should be able to determine each other.
For decomposing a global relation, lossless decomposition is the necessary condition but functionally completeness problem is not a necessary condition.
A relation in BCNF may or may not be functionally complete
Correct Answer: B
Question 8 Explanation: 
Functional Completeness Condition: It is the condition used to check the equivalence(The condition that all the data of the global relation must be mapped into the fragments) between global relation and its fragments after decomposition. When a relation is decomposed into fragments, both global relation and its fragments should be able to determine each other.
For decomposing a global relation, lossless decomposition is the necessary condition but functionally completeness problem is not a necessary condition.
A relation in BCNF may or may not be functionally complete
0 0 votes
Article Rating
Subscribe
Notify of
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x
error: Alert: Content selection is disabled!!