Question: An ERP system, such as SAP, uses a normalised database to minimise data redundancy. (a) Explain how this works by using an example from the

An ERP system, such as SAP, uses a normalised database to minimise data redundancy.

(a) Explain how this works by using an example from the GBI modules to support your answer.

(b) Explain how using a normalised database helps improve information quality, with reference to the information quality goals.

Step by Step Solution

★★★★★

3.38 Rating (148 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

a In an ERP system like SAP a normalized database structure is used to minimize data redundancy Normalization is the process of organizing data in a database to eliminate data duplication and ensure d... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Portray in words what transforms you would have to make to your execution to some degree (a) to accomplish this and remark on the benefits and detriments of this thought.You are approached to compose...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

can someone solve this Modern workstations typically have memory systems that incorporate two or three levels of caching. Explain why they are designed like this. [4 marks] In order to investigate...

Certain companies regard the management of cultural diversity as a way of developing new competencies that give them certain advantages. They are, for example, able to recruit and hold on to good...

Compare and contrast ABC transport systems with group translocation.

LO.1, 4 Rank the items below from most reliable to least reliable: a. Letter Ruling. b. Legislative Regulation. c. Code Section. d. Revenue Ruling. e. Proposed Regulation. f. Interpretive Regulation....

Let A1, A2, be a sequence of events defined in a sample space , and let a new sequence {Cn}n1 be defined by Then, {Cn}n1 is a decreasing sequence of events in . 00 CA = 1, 2,.... n i=n+1

Tim Madsen is the purchasing agent for Computer Center, a large discount computer store. He has recently added the hottest new computer, the Power model, to the stores stock of goods. Sales of this...

Vanessa Company is evaluating a project requiring a capital expenditure of $480,000. The project has an estimated life of 4 years and no salvage value. The estimated net income and net cash flow from...

Caspian Sea Drinks needs to raise $47.00 million by issuing additional shares of stock. If the market estimates CSD will pay a dividend of 51 45 next year, which will grow at 3.60% forever and the...

What are the role of supervisors ?

Cheyenne Vision Inc. opened for business on Jan 1, and uses a perpetual inventory system. During January, the company had the following purchases and sales for one of its products: Purchases Sales...

A cube with edge length L = 0.25 m and density Q = 0.88103 kg/m floats in equilibrium in a liquid of density = 15103 kg/m3, with the top of the cube a distance d above the liquid's surface, as shown...

Hill Corp. had 600,000 shares of common stock outstanding on January 1, issued 900,000 shares on July 1, and had income applicable to common stock of $1,050,000 for the year ending December 31, 2010....

7.1 A mammography center performs eleven different procedures. The volume of each procedure during an eight-month period and the standard hours per procedure are shown in Table EX 7.1. Table EX 7.1...

q3 / please answer asap and do not copy from the internet because there is plagiarism check. Question 3: (7.5 p) The picture below shows VMS in use on the M25 motorway. It also shows a variable speed...

Fred Farmer needs to prepare a balance sheet for his bank. He spent the day getting the following information. Fred needs your help to build a balance sheet and evaluate it. The information was...

Cis-1, 2-Dichloroethylene and trans-dichloroethylene are isomers, compounds with the same formula but different chemical structures. Look at the following electrostatic potential maps, and tell...

Draw the structure of an alternating segment of butyl rubber, a copolymer of isoprene (2-methyl-1, 3-butadiene) and isobutylene (2-methylpropene) prepared using a cationic initiator.

Draw an energy diagram for the addition of HBr to 1-pentene. Let one curve on your diagram show the formation of 1-brornopentane product and another curve on the same diagram show the formation of...

=+2 months, 2 years, and 10 years. With respect to the childs development, what features of each toy are especially good for a child of the intended age group?

=+4. Set aside 15 minutes to write a brief essay as follows. Think about your life in the future, when you are 70 or 80 years old. Imagine that everything has gone as well as it possibly could, and...

=+2. A major part of any childs life is playingand when kids are playing, they are often playing with toys. Using the information on perceptual and cognitive development reviewed in this chapter,...