DBMS Relational Decomposition - javatpoint
www.javatpoint.com/dbms-relational-decomposition
1 Users
0 Comments
6 Highlights
0 Notes
Tags
Top Highlights
When a relation in the relational model is not in appropriate normal form then the decomposition of a relation is required. In a database, it breaks the table into multiple tables.
If the information is not lost from the relation that is decomposed, then the decomposition will be lossless.
osition guarantees that the join of relations will result in the same relation as it was decomposed.
The relation is said to be lossless decomposition if natural joins of all the decomposition give the original relation.
In the dependency preservation, at least one decomposed table must satisfy every dependency.
If a relation R is decomposed into relation R1 and R2, then the dependencies of R either must be a part of R1 or R2 or must be derivable from the combination of functional dependencies of R1 and R2.
Ready to highlight and find good content?
Glasp is a social web highlighter that people can highlight and organize quotes and thoughts from the web, and access other like-minded people’s learning.