What are the three types of anomalies in database and
Explain?
Answer Posted / 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 |
Post New Answer View All Answers
What is a database lookup?
what is transaction state, buffer management, shadow paging
What is database client?
How do you connect to a database?
Which database is best to store images?
What does specialization in DBMS mean?
Display the employees whose salary is less than average salary.
what is tkprof tool and how it is used???
What is the relationship that exists inside in E-R diagram?
What is odm database?
Is data lake a database?
What is the difference between oracle and MS Access?
can we delete autodiff back up that we have set through sql server agent.
HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?
What is a Transformation?