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

how can we view column head in first page but not in remaining pages?

1608


What is the difference between specialization and generalization?

585


What is the role of tester in discovery(in Checklist)?

1461


Is redis in memory database?

545


Given a table of Player which contains Sno and player name, write a query which finds all possible Table Tennis doubles pairings.

928






When should you not use firebase?

617


What is a database lookup?

575


What is ole db ado?

557


What is database and its types?

562


Design an ETL process( batch job/script)from source to starting that u will not be dependent on the source in the near future?please elobarate details on what are things to consider.if you'd like to do a diagram that will be great.please answer it

1696


What is odm in database?

588


What is the difference between oracle and MS Access?

618


can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

2107


WHAT KIND OF TOOL BO IS?

1845


How heap is implemented in database?

645