Ask
Login
0
28kviews
Explain lossless join decomposition and dependency preserving decomposition.
written 9.4 years ago by gravatar for teamques10 teamques10 ★ 70k •   modified 3.9 years ago

Mumbai University > Computer Engineering > Sem 4 > Database Management System

Marks: 5M

Year: May 2014
database management systems
ADD COMMENT EDIT
1 Answer
3
360views
written 9.4 years ago by gravatar for teamques10 teamques10 ★ 70k

Lossless Join Decomposition:

  • The lossless join property is a feature of decomposition supported by normalization. It is the ability to ensure that any instance of the original relation can be identified from corresponding instances in the smaller relations.

    R : relation, F : set of functional dependencies on R,

    X,Y …

Create a free account to keep reading this post.

and 3 others joined a min ago.

ADD COMMENT EDIT
Please log in to add an answer.