What are the desirable properties of a decomposition

Related MCQs

• R (A,B,C,D) is a relation. Which of the following does not have a lossless join dependency preserving BCNF decomposition?
• Consider a schema R(A, B, C, D) and functional dependencies A -> B and C -> D. Then the decomposition of R into R1 (A, B) and R2(C, D) is
• In decomposition technique of splitting a relation into_____ relation:
• The relation employee(ID,name,street,Credit,street,city,salary) is decomposed into employee1 (ID, name) employee2 (name, street, city, salary) This type of decomposition is called
• Which property ensures that each functional dependency is represented in some individual relations resulting after decomposition?
• In the process of decomposition is called as
• Which normal form is most desirable ?
• What is ACID properties of Transactions?
• What is ACID properties of Transactions?
• An                  is a set of entities of the same type that share the same properties, or attributes.