Learning activity - normalization

Assignment Help Database Management System

Reference no: EM133055140

Learning Activity - Normalization

The relation below shows a customer list with the customer id, customer name, the bank manager, the bank name, the region that the bank is in and the managers salary

Discuss the following:

What happens if we need add another customer?

What kind of anomaly is this an example of?

What happens if Li Shilin gets a pay raise?

What potential issues might this lead to?

What happens if the NAB decides to close its eastern branch?

What kind of anomaly could this lead to?

What happens if the St George takes over the CBA branch the West region?

What information do we lose?

Normalise this relation to third normal form. Whenever you create a new relation in the normalisation process, describe the reason that it was required. What type of anomaly is avoided with the new relation?

Reference no: EM133055140

Questions Cloud

How much should be reported as premium expense : Lancer Company placed a coupon redeemable for a premium in each package of cereal sold at P200. How much should be reported as premium expense

Quantitative methods of business : a) jump! jumps onto delivering first-class service to business class holders and sets up a special lounge for their passengers. To set up the lounge there is a

Write a short research proposal : Write a short research proposal, which should contain only the following sections. (The marks per section appears in brackets)

How much shall be the provision for liability : Milder Company has guaranteed a loan of P300,000 granted to Miller Company. How much shall be the provision for liability

Learning activity - normalization : Describe the reason that it was required. What type of anomaly is avoided with the new relation?

What affects the decision-making process : After watching the video, how do you describe the process of the decision-making process, and what affects the decision-making process?

Organization business-level strategy : Are you aware of your organization's business-level strategy? What do you do to help your firm either increase differentiation or lower costs?

Create a new relation in the normalisation process : Whenever you create a new relation in the normalisation process, describe the reason that it was required - The Teaching Status field indicated

Describe four elements of governance objectives : Describe roles and responsibilities of governance. Describe four elements of governance objectives.

User Account

All Pages