Question (DATABASE) :

What fragmentation type to use to create fragmentation from the customer table below? give an explanation of how the fragment was finish, give a reason too why picking this fragmentation and draw how the fragmentation result table, please portray it suit to the three rules (reconstruction, completeness, disjointness).

Details :

Database created to distributed at certain branch areas. Below is a customer table example :

Customer Code Customer Name Gender Address Branch 6020010 Davin White Male Northall Green 95 Hart Road NR20 8RS 6010010 Jordan Ford Male Woottoon Bridge 27 Oxford Rd PO33 70G 6010010 Alexandra Howe Female Upton 64 Duckpit Lane CH49 OEE 6020020 Adam Brand Male 100 Park Row EH8 Edinburgh 3AB 6030050 Anna Lee Female 117 Ploughley Rd DT2 6WJ Toller Fratrum Customer Code Customer Name Gender Address Branch 6020010 Davin White Male Northall Green 95 Hart Road NR20 8RS 6010010 Jordan Ford Male Woottoon Bridge 27 Oxford Rd PO33 70G 6010010 Alexandra Howe Female Upton 64 Duckpit Lane CH49 OEE 6020020 Adam Brand Male 100 Park Row EH8 Edinburgh 3AB 6030050 Anna Lee Female 117 Ploughley Rd DT2 6WJ Toller Fratrum