Questiona bank has its head office in stoke it has two

Assignment Help Computer Engineering

Reference no: EM13349145

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: EM13349145

Questions Cloud

Questionthe school course catalog reads as follows to enrol : questionthe school course catalog reads as follows to enrol in mgt 580 that is an advanced course a student must

Question1 why is it significant to control changes to asset : question1. why is it significant to control changes to asset baselines?2. why is the labelling process approached

Questionexplain contents of an initially empty avl tree at : questionexplain contents of an initially empty avl tree at the end of each of following sequences of operations-i.

Questionwrite down a c program that reads n positive : questionwrite down a c program that reads n positive numbers from keyboard calculates and displays following-1. count

Questiona bank has its head office in stoke it has two : questiona bank has its head office in stoke. it has two branches one in longton and other in burslem. each customer

Questiona computer system has an 8-bit address bus an 8-bit : questiona computer system has an 8-bit address bus an 8-bit data bus and control signals read and write. the cpu for

Questionin following case statement replaces the 14 7 3 : questionin following case statement replaces the 14 7 3 with values that are pulled from a table known as

Questioninformation representationa security camera in an : questioninformation representationa security camera in an office building has 1000 x 1000 pixels. each pixel shows a

Question1 which of following statements is true a an md : question1. which of following statements is true? a an md could be an administrator b an rn can be an administrator c

User Account

All Pages