Author Question: List and describe the four anomalies that may occur when creating database tables. What will be ... (Read 61 times)

magmichele12

  • Hero Member
  • *****
  • Posts: 559
List and describe the four anomalies that may occur when creating database tables.
 
  What will be an ideal response?

Question 2

Bar codes encode text, graphics, and data into small rectangular dots on a narrow strip of paper.
 
  Indicate whether the statement is true or false



xMRAZ

  • Sr. Member
  • ****
  • Posts: 363
Answer to Question 1

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.

Answer to Question 2

FALSE



Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
 

Did you know?

Though newer “smart” infusion pumps are increasingly becoming more sophisticated, they cannot prevent all programming and administration errors. Health care professionals that use smart infusion pumps must still practice the rights of medication administration and have other professionals double-check all high-risk infusions.

Did you know?

The first successful kidney transplant was performed in 1954 and occurred in Boston. A kidney from an identical twin was transplanted into his dying brother's body and was not rejected because it did not appear foreign to his body.

Did you know?

In the United States, an estimated 50 million unnecessary antibiotics are prescribed for viral respiratory infections.

Did you know?

There are approximately 3 million unintended pregnancies in the United States each year.

Did you know?

In the ancient and medieval periods, dysentery killed about ? of all babies before they reach 12 months of age. The disease was transferred through contaminated drinking water, because there was no way to adequately dispose of sewage, which contaminated the water.

For a complete list of videos, visit our video library