Question
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,
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).
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started