desirable properties of decomposition, Database Management System

Desirable Properties Of Decomposition

Decomposition is a process of dividing a relation into its projections that will not be disjoint. Please remind the Relational projection operator and keep in mind no duplicate tuples are allowed in a projection.

Desirable properties of decomposition are given below:

  • Lossless-join decomposition
  • Attribute preservation
  • Dependency preservation
  • Lack of redundancy


Posted Date: 3/7/2013 2:15:39 AM | Location : United States

Related Discussions:- desirable properties of decomposition, Assignment Help, Ask Question on desirable properties of decomposition, Get Answer, Expert's Help, desirable properties of decomposition Discussions

Write discussion on desirable properties of decomposition
Your posts are moderated
Related Questions
Discuss the term- Design Optimization  We have seen various ways of representing the objects.The fundamental design model uses analysis model as the framework for implementati

let us consider a table having 2200 records and the fixed size of the table to be considered as 25.then how many numbers of table is requredto perform horizontal fragmentation

Explain the conventions for displaying an ER schema as an ER diagram? An E-R Diagram scheme might describe certain constraints to that the contents of a database must conform.

What are axioms? Axioms or rules of inference give a simpler technique for reasoning about

Data Base Management System 1. Draw the Architecture of MySQL and explain about its subsystems briefly. 2. Elaborate with the help of an example the concept of Primary key a

File Organisation In Dbms Introduction Databases are used to store information. Usually, the principal operations we have to perform on database are those relating to:

Explain degree of relation? Degree of a Relation - The degree or arity of a relation is the number of attributes n of its relation schema.

ADVANCE OBJECT DESIGN Introduction Analysis is the initial step of the OMT methodology. It is apprehensive with devising a precise, concise, correct and understandable mo

Cardinality shows the number of instances of an entity associated with another entity participating in a relationship. Depend on the cardinality binary relationship can be further

What are segments in oracle? Segments - Each table has single field of disk space, known as segment, set aside for it in the tablespace. Segments consist of contiguous sections