What are the three types of anomalies in database and
Explain?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between specialization and generalization?
can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?
What is ole db in ssis?
How do I manually create a database?
what is ad-hoc access? what is the diff b/w managed query and ad-hoc access?
Explain various types of locks in a transaction? Which is better and why?
What is the difference between a stored procedure and a query?
What does new grouping sets enables you to do?
Differentiate between extension & intension?
Is data lake a database?
What is ole db source in ssis?
What is the difference between primary key, foreign key and candidate key?
issues involved in modeling and building data werahouses
On startup, the transaction log of a database has filled and recovery has suspended, what can I do?
can we delete autodiff back up that we have set through sql server agent.