My three simple predicates are Dlocation = ”stafford”, Dlocation = ” Bellaire” , Dnumber = 5

My three simple predicates are Dlocation = ”stafford”, Dlocation = ” Bellaire” , Dnumber = 5


2:

My two minterm predicates for this table are

Dlocation = ”Bellaire” ^ Dnumber = 5

Dlocation = ”Stafford” Dnumber = 4

3:

We decided to fragment and our fragmentation predicate is

Fragment1: Dnumber = 1

Fragment2: Dnumber = 2

Fragment3: Dnumber > 5

Fragment1: Dnumber = 1

One record

Fragment2: Dnumber = 2

No records

Fragment3: Dnumber > 5

No records

4:

NO, it doesn’t ensure completeness. The reason why that is because in order to guarantee completeness of fragmentation, there is a substantial condition has to be occurred which is each data item in R has to found in some Rn. In other words, there should be no loss of info when we do fragmentation. This condition has been violated by the fragmentation above.

5:

In order to modify the current fragmentation and obtain completeness, we should add fragments that get us the info for (Dnumber =4, Dnumber = 5)

Fragment 1: Dnumber <= 1

Fragment 2: Dnumber = 2

Fragment 3: 3<= Dnumber <=5

Fragment 4: Dnumber > 5