Reference no: EM133100979
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?
| CustomerID |
Name |
Manager |
Bank Name |
Region |
Salary |
| 1043 |
Hernandez |
Li Shilin |
St George |
South |
89000 |
| 9152 |
Rioli |
Vijay Singh |
CBA |
West |
100000 |
| 7495 |
Cheung |
Li Shilin |
St George |
South |
89000 |
| 8363 |
Nguyen |
Jana Lemumba |
Westpac |
West |
100000 |
| 8945 |
Tomba |
Vladimir Le Clerc |
NAB |
Eat |
95000 |
|
Make a statement of cash flows for Ehrlich Company
: Purchased machinery and gave a $60,000 long-term note payable. Make a statement of cash flows (using the indirect method) for 2021 for Ehrlich Company
|
|
Keep a journal that Sea Limited Corp is required
: It is assumed that both transactions are made in Yen. Keep a journal that Sea Limited Corp is required on the transaction date and settlement date
|
|
What total amount would the ordinary shareholders receive
: If ABC Co. declares P3,500,000 cash dividend, What total amount would the ordinary shareholders receive if preference shares are cumulative and participating
|
|
Research economic climate surrounding two accounting scandal
: Research the economic climate surrounding two accounting scandals. What major changes occurred as a result of the accounting scandals
|
|
Normalise this relation to third normal form
: Normalise this relation to third normal form - create a new relation in the normalisation process, describe the reason that it was required
|
|
What is the capital gains yield on your investment
: At that time, the index value was 11,251.80. Today, the index value is 12,301.60. What is the capital gains yield on your investment
|
|
Determine the relative level of risk
: Determine the relative level of risk (high or low) of principal-agent problems being present at each company. Justify your viewpoints
|
|
What is depreciation for each year for the life of project
: New PPE cost $70,000,000 and installation $3,500,000. Salvage price of 9,000,000. What is the depreciation for each year for the life of the project
|
|
Carpet samples normalization
: Store the data for a carpet store where people are allowed to borrow carpet samples - Provide some bullet points on the potential issues with the structure
|