Ownership of data in traditional legacy systems often leads to data redundancy. This in turn leads to several data management problems. What are they? How does the database approach solve them?
Data redundancy causes significant data management problems in three areas: data storage, data updating, and currency of information. Data storage is a problem because if multiple users need the data, it must be collected and stored multiple times at multiple costs. When multiple users hold the same information, changes must be updated in all locations or data inconsistency results. Failure to update all occurrence of a data item can affect the currency of the information.
With a database system, these problems are solved. There is no data redundancy since a data item is stored only once. Hence changes require only a single update, thus leading to current value.
You might also like to view...
The ______________________________ manager usually performs major buying activities as well as the required administrative duties of running a department
Fill in the blank(s) with correct word
Based on the following information, prepare a Schedule of Cost of Goods Manufactured and a multi-step Income Statement for Junaluska Company for the year ended December 31, 2020
The sales process is a sequential series of actions by the salesperson that leads toward the customer taking a desired action and ends with a follow-up to ensure purchase satisfaction.
Answer the following statement true (T) or false (F)
Graham Company has 15,000 units in inventory that had a production cost of $3 per unit. These units cannot be sold through normal channels due to a significant technology change. These units could be reworked at a total cost of $23,000 and sold for $28,000 . Another alternative is to sell the units to a junk dealer for $8,500 . The relevant cost for Graham to consider in making its decision is
a. $45,000 of original product costs. b. $23,000 for reworking the units. c. $68,000 for reworking the units. d. $28,000 for selling the units to the junk dealer.