In the process of decomposition is called as

Related MCQs

• 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
• What are the desirable properties of a decomposition
• 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:
• Which property ensures that each functional dependency is represented in some individual relations resulting after decomposition?
• The entity set person is classified as student and employee. This process is called
• There are similarities between the instructor entity set and the secretary entity set in the sense that they have several attributes that are conceptually the same across the two entity sets: namely, the identifier, name, and salary attributes. This process is called
• What is the process that is done to SQL before execution, to check for proper syntax and to optimize the request called?
• In ER model the details of the entities are hidden from the user. This process is called: