Database System Questions

1. It is known that the customer table is initially stored in a centralized database server. To increase efficiency in access and operational costs, the database is distributed across several branch areas. An example of a customer table looks like this:

1. There are several types of fragmentation, explain! What type do you use when fragmentation of the table above? Explain how the fragmentation was done and give reasons why choosing this type!
2. Describe how the fragmented table looks like and describe it according to 3 rules (completeness, reconstruction, disjointness).

P.S:

- Please answer in a proper format - Please answer in a typed or softcopy format - Please don't do it with pen or pencil, do it with software or tools - If you want to ask any question, ask it in the comment section, I will try to answer it

Thanks!

Customer Code Customer Name Gender Address Branch JL Anggrek No. 200 No. 202001 John White Male Jakarta 5 Jakarta Griya Indah Blok A1/J 201001 David Ford Male No.5 Bandung, Jawa Bandung Barat JL Bandung Raya No.8 201001 Mary Howe Female RT 01/RW 04 Bandung Bandung Jawa Barat JL Petukangan No.39 202002 Susan Brand Male Jakarta RT 01/RW 03 Jakarta, Perumahan Loka No.3 203005 Julie Lee Female Jakarta Jakarta. Customer Code Customer Name Gender Address Branch JL Anggrek No. 200 No. 202001 John White Male Jakarta 5 Jakarta Griya Indah Blok A1/J 201001 David Ford Male No.5 Bandung, Jawa Bandung Barat JL Bandung Raya No.8 201001 Mary Howe Female RT 01/RW 04 Bandung Bandung Jawa Barat JL Petukangan No.39 202002 Susan Brand Male Jakarta RT 01/RW 03 Jakarta, Perumahan Loka No.3 203005 Julie Lee Female Jakarta Jakarta