IT 450 - Ch. 6 Anomaly Types

0.0(0)
Studied by 0 people
call kaiCall Kai
learnLearn
examPractice Test
spaced repetitionSpaced Repetition
heart puzzleMatch
flashcardsFlashcards
GameKnowt Play
Card Sorting

1/4

encourage image

There's no tags or description

Looks like no tags are added yet.

5 Terms

1
New cards

Insertion Anomaly

Occurs when new information cannot be added without also adding unnecessary or unrelated data. Example: You cannot add a new employee unless they are assigned to a project. Memory trick: Can't ADD.

2
New cards

Update Anomaly

Occurs when the same information is stored in multiple rows and must be updated everywhere to avoid inconsistencies. Example: An employee's job title changes, but only some records are updated. Memory trick: Can't CHANGE consistently.

3
New cards

Deletion Anomaly

Occurs when deleting one record unintentionally removes other important information. Example: Deleting the last employee assigned to a project also deletes the project's information. Memory trick: Can't DELETE without losing something else.

4
New cards
Data Redundancy
Occurs when the same information is unnecessarily stored in multiple places. Example: An employee's phone number appears in 20 different records. Memory trick: DUPLICATE data.
5
New cards
Data Inconsistency
Occurs when different copies of the same information contain conflicting values. Example: An employee's phone number is updated in one record but remains outdated in another. Memory trick: CONFLICTING data.