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

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?

1883


How do I manually create a database?

562


how node connect with cpu?

1659


What is the role of driver manager?

581


How does non-cluster index functions?

637






How does database replication work?

554


Which database does facebook use?

512


sparse lookup and where its options we find in OCI and db2?

1739


where can i free download sqlserver2008..i can install sqlserver2008 without visual studio 2008 and work on it

1577


What is the Lock Based Protocol used for?

635


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

560


Define stored procedure?

599


What the various ways to tune a teradata query

2788


hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com

1940


What is difference between data and database?

549