Author Question: List and describe the four anomalies that may occur when creating database tables. What will be ... (Read 63 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?

In the United States, there is a birth every 8 seconds, according to the U.S. Census Bureau's Population Clock.

Did you know?

Children of people with alcoholism are more inclined to drink alcohol or use hard drugs. In fact, they are 400 times more likely to use hard drugs than those who do not have a family history of alcohol addiction.

Did you know?

Although puberty usually occurs in the early teenage years, the world's youngest parents were two Chinese children who had their first baby when they were 8 and 9 years of age.

Did you know?

Many medications that are used to treat infertility are injected subcutaneously. This is easy to do using the anterior abdomen as the site of injection but avoiding the area directly around the belly button.

Did you know?

In inpatient settings, adverse drug events account for an estimated one in three of all hospital adverse events. They affect approximately 2 million hospital stays every year, and prolong hospital stays by between one and five days.

For a complete list of videos, visit our video library