List and describe the four anomalies that may occur when creating database tables
What will be an ideal response?
1. Data redundancy occurs when the same data are stored in more than one place in the database.
2. An insert anomaly occurs when the entire primary key is not known and the database cannot insert a new record, which would violate entity integrity.
3. A deletion anomaly happens when a record is deleted, resulting in the loss of other related data.
4. An update anomaly results when a change to one attribute value either causes the database to contain inconsistent data or causes multiple records to need changing.
You might also like to view...
How does positive reinforcement encourage a behavior to be repeated?
A) By removing an unpleasant outcome. B) By using punishment to diminish unwanted behavior. C) By minimizing stress and job burnout. D) By adding an unpleasant outcome. E) By offering pleasant consequences for a particular action or behavior.
Under the U.S. Sentencing Guidelines, companies that violate environmental laws may face reduced penalties if they have an internal environmental compliance program
a. True b. False Indicate whether the statement is true or false