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
Surgeons identified by doctor ID (DOCID) operate on patients identified by patient ID (PATID) in operating theaters identified by room numbers (ROOMNO). Each surgeon can operate on


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.

Express the ways provided by MySQL for Pattern Matching? MySQL provides two kinds of pattern matching. 1) One is based on SQL patterns 2) Regular expressions.

Data Independence This brings us to our next topic: data independence. It is the property of the database which tries to make sure that if we make any change in any level of sc

how to implement hyrise in C plus plus

Atomicity : Either all functions are laid out or none are. Users could not have to think about the effect of incomplete operations. DBMS ensures this by undoing the functions

i am not clear with the climetic condition of the north indian plain. can u plz explain it for me

Fundamentals of Database Management 1. Explain the concept of Foreign Key. How a foreign key differs from a Primary Key? Can the Foreign Key accept nulls? 2. With a necess

Create centralized relational database using Top down method- Construction of Logical Model: Translation EERD into Relational Schema: Use the 8 steps algorithm of converting EERD