Database Systems

It is known that the customer tables are initially stored in a centralized database server. To increase efficiency in access and operational costs, the database was made distributed in several branch areas. An example of a customer table is as follows.

Customer Code	Customer name	Gender	Address	Branch
202001	John White	M	1922 Alice Street, Dothan, AL 36301	Alaska
201001	David Ford	M	5136 Miriam St, Los Angeles, CA 90042	Los Angeles
201001	Mary Howe	F	4312 9th Avenue, Los Angeles, CA 90008	Los Angeles
202002	Susan Brand	M	411 Summerville Ln, Jasper, AL 35504	Alaska
203005	Julie Lee	F	900 POPLAR DRIVE, Fairbanks, AK 99709	Alaska

a. There are several types of fragmentation, explain! What type do you use if you do fragmentation of the table above? Explain how the fragmentation is done and give reasons why choosing this type!

b. Describe how the fragmented table looks like and describe it according to 3 rules (completeness, reconstruction, disjointness).