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
5. Explain about relational algebra.
What is dialect in database?
What advantages does DBMS have over traditional file systems?
Which is the best graph database?
Explain phantom deadlock?
What are the advantages of views in a database?
What is the function of cluster index?
Explain file manager?
Is data lake a database?
Which database does facebook use?
how can we view column head in first page but not in remaining pages?
How does non-cluster index functions?
What is odm in database?
How many types of locks are present in a database?
query to Compare data of two tables between two different Databases(Oracle and SQL Server) Eg., Source Database: Oracle Table: Employee Target Database : SQL Server Table : emp