What are the three types of anomalies in database and
Explain?

Answers were Sorted based on User's Feedback



What are the three types of anomalies in database and Explain?..

Answer / pooja

there are basically three types of anomalies in database:
1. insertion anommalies
2. updation anomalies
3. deletion anomalies

Is This Answer Correct ?    212 Yes 25 No

What are the three types of anomalies in database and Explain?..

Answer / irshad ahmad

Anomalies are problems that arise in the data due to a flaw
in the database design. There are three types of anomalies….
*Insertion Anomalies:Insertion anomalies occur when we
try to insert data into a flawed table.
*Deletion Anomalies:- Deletion anomalies occur when we
delete data from a flawed schema.
*Update Anomalies:- Update anomalies occur when we
change data in a flawed schema.

Is This Answer Correct ?    146 Yes 21 No

What are the three types of anomalies in database and Explain?..

Answer / rajabmatalingana@yahoo.com

Anomalies are problems which arises when changes are made to
the database.
There are three types of anomalies:
>INSERTIN-This problem occurs due to inability to represent
a certain information example;when information about new
cannot be inserted in a DB,
>DELETION-This occurs due to loss of useful information
Example;when we delete information in a DB we will loss
relevant information.
>UPDATE-This type occurs due to redundant information make
difficult to update

Is This Answer Correct ?    43 Yes 8 No

What are the three types of anomalies in database and Explain?..

Answer / a.h nayeem

INSERT Anomaly
1)An insertion anomaly occurs when data cannot be inserted into a database due to other missing data
2)This is most common for fields where a foreign key must not be NULL, but lacks the appropriate data
3)An example of this anomaly can be explained with a simple user database
..A user must have a group ID as a foreign key
..No groups have yet been created
..Thus, a user can not be inserted in to the database as the group ID must not be NULL
4)This can result in data redundancy due to the omission of data.


DELETE Anomaly
1)A deletion anomaly occurs when data is unintentionally lost due to the deletion of other data
2)For example, if a database row contained "Username" and "User Group"
.."John" and "Fred" are in the user group "Contributors"
..If John and Fred are removed from the database, our Contributors group will also disappear
..This is because we haven't normalised our data, meaning the only reference to the Contributors user group lies within the same database row (or record)
..Hence, removing the only two references of our user group results in the loss of data accuracy and integrity
3)This also goes to show why it's important for us to normalise our data and how combining unlike information can be problematic


UPDATE Anomaly
1)An update anomaly occurs when data is only partially updated in a database.
2)A database that hasn't undergone normalisation may reference the same data element in more than one location.
3)As these locations haven't been consolidated and referenced, we have to make sure each location is manually updated
4)This can cause problems as we then need to spend time searching for and updating each reference to the data element.
5)An example of this is a database containing two records; Users and Mailing List.
..John has an email address of john@mail.com in the Users record.
..John has the same email address in the Mailing List record.
..John decides to change his email preferences, which in turn updates the User record for John.
..However, the system did not automatically update the Mailing List record, leaving John with two different associated emails and thus creating inconsistencies within our database.

Is This Answer Correct ?    25 Yes 1 No

What are the three types of anomalies in database and Explain?..

Answer / shashank shekhar

Three Anomalies are:-
Insertion Anomalies.
Deletion Anomalies.
Modification Anomalies.

Is This Answer Correct ?    41 Yes 22 No

What are the three types of anomalies in database and Explain?..

Answer / melkamu wondie

insertion anomalies
update anomalies
deletion anomalies

Is This Answer Correct ?    20 Yes 10 No

What are the three types of anomalies in database and Explain?..

Answer / mue timothy

Update anomalies-data inconsistency that results from data redundancy and partial update.
Deletion anomalies-unintended loss of data due to the deletion of other data.
Insertion anomalies-the inability to add data to the database due to the absence of other data.

Is This Answer Correct ?    12 Yes 5 No

What are the three types of anomalies in database and Explain?..

Answer / safiullah

there are three type of anomaly
1)insertion anomaly
2)deletion anomaly
3)modification anomaly
INSERTION ANOMALY occur when certain attribute cannot be inserted into the database without the presence of other attribute.
DELETION ANOMALY exist when certain attributes are lost because of the deletion of other attribute.
ANOMALY's MODIFICATION occur when we are not able to modifying the record in database without takecare of other facts.

Is This Answer Correct ?    5 Yes 2 No

What are the three types of anomalies in database and Explain?..

Answer / sanket mishra

there are 3 types of irregularity in a database i.e.

insertion irregularity
updation irregularity
deletion irregularity

Is This Answer Correct ?    19 Yes 31 No

Post New Answer

More Databases AllOther Interview Questions

What is a database lookup?

0 Answers  


what is difference between delete and truncet ?

7 Answers   Fidelity,


what is the difference between tuple calculus and domain calculus ?

2 Answers   Infosys,


A design problem was given in which I was supposed to make a design for the data base for a given problem.

0 Answers   Motorola,


Write a query to get maximum and second maximum in oracle?

0 Answers   CGI,






what are wrappers and build ups and what it's use?

0 Answers   TCS,


List some advantages of dbms.

0 Answers  


Explain the various types of normalization.

0 Answers  


a __________ is a virtual table made up of subset of actual table

2 Answers  


How to implement database security?

0 Answers  


How many types of normalization? What is the use of it?

0 Answers   Accenture,


What is difference between data and database?

0 Answers  


Categories