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
Ask qu. Write a XML with database with book details (Book ID, Title, Author, subject, published year, language, vendor, and price).estion #Minimum 100 words accepted#

What does authentication refer? Authentication refers to the task of verifying the uniqueness of a person.

Explain the uses of deadlock It will lead to deadlock since this is the only place where incoming acknowledgements are processed. Without this code, sender will keep timing ou

Compare wait-die deadlock prevention scheme with wait-wound scheme   Ans:  Wait-Die Scheme  a) Based upon a nonpreemptive technique.  b) If Pi requests a resource present

Question: (a) One of the steps in the five-step problem-solving model is implementation. Implementation is considered a key step in the problem-solving model. A problem may be

What is called as recursive partitioning? The system repeats the splitting of the input unless each partition of the build input fits in the memory. Such partitioning is known

Write the syntax of creating an INDEX ? Syntax of Creating an Index: CREATE [BITMAP] [UNIQUE] INDEX ON ( [, ] . . .);

What do you mean by DBMS? What is its need and what are its goals. Explain?        OR   Explain Data Base Management System? Sol.  Database management system is a

Every simple attribute of an entity type have a possible set of values that can be attached to it. This is known as the domain of an attribute. An attribute cannot have a value out

What are the benefits of document scanning? Document scanning, in addition to being cost-efficient, also enhances productivity. This service enhances security as you set the pa