Write down the correctness rules for VF
Answer:
Correctness Rules for Verifying Fragmentation:
Basically fragmentation is a major part of DDBMS. We have to fragment the tables of data
vertically and horizontally and also distribute the data at different sites at different locations
because everyone can access the data easily. When we fragment and distribute the data the
following result will be kept in our mind.
1. we have to keep in our mind our data will not be loose during the fragmentation.
2. We have to ensure that our data in database in cannot be duplicated.
There are basically three rules for verifying fragmentation.
1. Completeness
2. Reconstruction
3. Disjointness
Completeness:
The first rules of fragmentation is completeness in this rule we have to ensure that our data will
not be loose during the fragmentation. When fragmentation is once complete we have to ensure
that the data is in record at least found in one fragments after the fragmentation.
Reconstruction:
The second rule of fragmentation is reconstruction in this we have to re-construct the original
table of data with fragments which are created after the fragmentation.
Disjointness:
This is third rule of fragmentation is Disjointness in this we have to ensure that data in record
will not become the part of different fragments after the fragmentation process.
Answer:
Correctness Rules for Verifying Fragmentation:
Basically fragmentation is a major part of DDBMS. We have to fragment the tables of data
vertically and horizontally and also distribute the data at different sites at different locations
because everyone can access the data easily. When we fragment and distribute the data the
following result will be kept in our mind.
1. we have to keep in our mind our data will not be loose during the fragmentation.
2. We have to ensure that our data in database in cannot be duplicated.
There are basically three rules for verifying fragmentation.
1. Completeness
2. Reconstruction
3. Disjointness
Completeness:
The first rules of fragmentation is completeness in this rule we have to ensure that our data will
not be loose during the fragmentation. When fragmentation is once complete we have to ensure
that the data is in record at least found in one fragments after the fragmentation.
Reconstruction:
The second rule of fragmentation is reconstruction in this we have to re-construct the original
table of data with fragments which are created after the fragmentation.
Disjointness:
This is third rule of fragmentation is Disjointness in this we have to ensure that data in record
will not become the part of different fragments after the fragmentation process.
