Author Question: A derived element is one that: A) is keyed, derived by the users. B) has several different ... (Read 38 times)

Themember4 · **on:** Jul 7, 2018

A derived element is one that:

A) is keyed, derived by the users.
B) has several different meanings, one for each user group.
C) is created by processes as a result of calculations or a series of decision-making statements.
D) has the displayed length and the stored length the same.

Question 2

Explain update anomalies and provide examples.

What will be an ideal response?

scikid · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

C

Answer to Question 2

Update anomalies occur when you have to update the same data in several different spots. If a customer, for instance, has several different kinds of accounts, and their contact information is stored in separate tables for each of those accounts, then any change in their contact information would have to be updated in each of those accounts. This greatly increases the chance of mistakes in entry and inconsistent information.