menu
bartleby
search
close search
Hit Return to see all results
close solutoin list

Given the scenario and requirements in Problem 2, answer the following questions: a. What recommendations will you make regarding the type and characteristics of the required database system? b. What type of data fragmentation is needed for each table? c. What criteria must be used to partition each database? d. Design the database fragments. Show an example with node names, location, fragment names, attribute names, and demonstration data. e. What type of distributed database operations must be supported at each remote site? f. What type of distributed database operations must be supported at the headquarters site?

BuyFindarrow_forward

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482

Solutions

Chapter
Section
BuyFindarrow_forward

Database Systems: Design, Implemen...

12th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781305627482
Chapter 12, Problem 3P
Textbook Problem
144 views

Given the scenario and requirements in Problem 2, answer the following questions:

  1. a. What recommendations will you make regarding the type and characteristics of the required database system?
  2. b. What type of data fragmentation is needed for each table?
  3. c. What criteria must be used to partition each database?
  4. d. Design the database fragments. Show an example with node names, location, fragment names, attribute names, and demonstration data.
  5. e. What type of distributed database operations must be supported at each remote site?
  6. f. What type of distributed database operations must be supported at the headquarters site?

Explanation of Solution

a. Recommendations of required database system:

Recommendations make regarding the type and characteristics of the required data base system are as follows:

  • • The magazine publishing organization wants a distributed system with distributed database capabilities.
  • • The distributed system will be distributed among the organization locations in Tennessee, South Carolina, Florida, and Georgia...

Explanation of Solution

b. Data fragmentation needed for tables:

The data fragmentation needed for “CUSTOMER”, and “INVOICE” table is as follows:

The datab...

Explanation of Solution

c. Criteria used to partition the database:

The criteria “horizontal fragmentation” is used to partition the database.

Horizontal fragmentation of the “INVOICE” table by region is as follows:

Fragment nameLocationConditionNode name
I1TennesseeREGION_CODE = “TN”NAS
I2GeorgiaREGION_CODE = “GA”ATL
I3FloridaREGION_CODE = “FL”TAM
I4South Carol...

Explanation of Solution

d. Database fragments:

Following are the database fragments with node names, location, fragment names, attribute names, and demonstration data.

Fragmentation of “INVOICE” table:

Fragment “I1” of “INVOICE” table with location “Tennessee”, and node “NAS” is as follows:

INV_NUMREGION_CODECUS_NUMINC_DATEINV_TOT
213342TN108841-NOV-1545.95
209987TN1099315-FEB-1645.95

Fragment “I2” of “INVOICE” table with location “Georgia”, and node “ATL” is as follows:

INV_NUMREGION_CODECUS_NUMINC_DATEINV_TOT
198893GA1188715-AUG-1570.45
224345GA135581-JUN-1645.95

Fragment “I3” of “INVOICE” table with location “Florida”, and node “TAM” is as follows:

INV_NUMREGION_CODECUS_NUMINC_DATEINV_TOT
200915FL100141-NOV-1545.95
231148FL159981-MAR-1624.95

Fragment “I4” of “INVOICE” table with location “South Carolina”, and node “CHA” is as follows:

INV_NUMREGION_CODECUS_NUMINC_DATEINV_TOT
243312SC2156215-NOV-1545.95
231156SC187761-OCT-1645.95

Fragmentation of “CUSTOMER” table:

Fragment “C1” of “CUSTOMER” table with location “Tennessee”, and node “NAS” is as follows:

CUS_NUMCUS_NAMECUS_ADDRESSCUS_CITYCUS_STATECUS_SUB_DATE
10884James D...

Explanation of Solution

e. Distributed database operations supported at each remote site:

The following table show the map of the location, the fragments at each location, and the type of transaction or request support to need to access the data in the distributed database.

FragmentNASATLTAMCHA
INVOICEI1

Explanation of Solution

f. Distributed database operations supported at headquarters site

The following table show the map of the location, the fragments at each location, and the type of transaction or request support to need to access the data in the distributed database.

FragmentNASATLTAMCHAHeadquarters

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
What is the fundamental difference between symmetric and asymmetric encryption?

Principles of Information Security (MindTap Course List)

A unit that is generally used to express the insulating value of clothing is called clo. 1 clo is equal to 0.15...

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

At what temperature do nitrogen atoms combine with oxygen atoms to form NOx?

Automotive Technology: A Systems Approach (MindTap Course List)

What is a task? What is an event? What is a milestone?

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

What are the different types of validity checks? (503)

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)