Suggest a fragmentation design of the account relation

Assignment Help Computer Engineering
Reference no: EM133094

Question

A bank has its head office in Stoke. It has two branches, one in Longton and other in Burslem. Each customer account belongs to 1 branch only. At present, company has 1 database located in the head office. Customers at branches entrance this database via a message network for whatever they need.

One of the relations in this centralised database system is Account relation, where data about accounts is kept. The attributes of Account relation are- the account number (Acc no), account type (Acc type), the customer's identification (assume Name), the branch where account is held, the current balance for the account (balance) and an indicator that tells head office if the publicity (information on updates to regulations, interest rates etc) for a account type for a customer has been sent out. An example of account relation is given below-

Acc No Acc Type Name Branch Balance Publicity
191688 002 Jones Burslem 2000 yes
779865 005 Smith Longton 600 no
158756 002 Green Longton 8 yes
125467 007 White Longton 10000 no
124678 005 Black Burslem 150 yes


The bank has determined to move to a distributed database system where each of sites has its own database. Suggest a fragmentation design of the Account relation that reflects the distribution of the company's sites and their functionality. Validate your proposal.

Reference no: EM133094

Questions Cloud

Produce a decision table : Produce a decision table
What is role of risk assessment : What is role of risk assessment
Explain contents of an initially empty avl tree : Explain contents of an initially empty AVL tree
Write a program that reads n positive numbers from keyboard : Write a program that reads N Positive numbers from keyboard
Suggest a fragmentation design of the account relation : Suggest a fragmentation design of the Account relation
Explain the design for the memory subsystem : Explain the design for the memory subsystem
Program to evaluate case statement : Program to evaluate case statement
What is the data rate : What is the data rate
Which of following statements is true : Which of following statements is true

Reviews

Write a Review

 

Computer Engineering Questions & Answers

  How to generate a hub-and-spoke network

How to generate a hub-and-spoke network

  How to create program that performs arithmetic function

How to create program that performs arithmetic function Prompt a user for values for the variables. Pass both variables to methods named sum() and difference().

  Write down a program that has a function named presentvalue

Write down a program that has a function named presentValue

  Program on wireless connection technology

Program on wireless connection technology.

  Which of following statements is true

Which of following statements is true

  Risk assessment of ict system

Risk Assessment of ICT System and Developing Computer Incident Response System on WAMP platform

  How a box of caramel delites girl scout cookies

How to a box of Caramel deLites Girl Scout cookies Every spring you looking forward to buying a box of Caramel deLites Girl Scout cookies

  How to store ten floating-point values into vector

How to store ten floating-point values into vector. Write down a program that declares a vector of ten floating-point values

  Write a program that mimics a flop-turn-river of poker game

Write down a program that mimics a flop-turn-river of a poker game. I must have three buttons titled Deal, Shuffle and Start Over.

  Develop a checkout lane simulation

Develop a checkout lane simulation that can be used to determine the optimal number of lanes that Cougar Mart should have open.

  The difference between roles and groups

The difference between roles and groups

  Describe the mechanics of Buffer overflows

Prepare a complete tutorial, including an analogy to describe the mechanics and a graphic to support your analogy, on one of the subsequent areas

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd