What are the some of the dangers of storing redundant data in a database? Provide an example
What will be an ideal response?
The main danger of redundant data is that the database will become inconsistent and inaccurate. When data is redundant--the same data stored in more than one place--it is easy to update the data in one place but fail to update it in the other. For example, consider a database where customer information is stored in two different tables and the customer changes his address. It is updated in one table and not in another. The data has become inaccurate and untrustworthy. It is no longer possible to know which is the correct address for that customer.
You might also like to view...
The ____________________ method most nearly approximates replacement cost of inventory on the balance sheet
Fill in the blank(s) with correct word
Each department in a company that carries out value-creating activities can be thought of as a link in the company's ________
A) channel of intermediaries B) external value stream C) demand chain D) internal value chain E) supplier chain
The problem-solving phase of collaboration involves a three-step process of brainstorming, evaluation, and rejection
Indicate whether the statement is true or false.
Inventories that are built up in advance of a peak selling season, a promotion program or a plant
shut-down are known as: A) lot-size inventories. B) transportation inventories. C) anticipation inventories. D) safety stocks. E) none of the above