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 ole db used for?
What is replicaset?
What is database client?
What is a Transformation?
What is a database string?
diff b/w inter process and in process
if i want to display the name of students such that to which city they belong must have count greaer than two
Explain alternate key?
How default key is different from primary key?
What is the concept of Virtual field?
Why do we need distributed database?
What are the concurrency problems a database faces?
How many indexes can be created on a table?
A lowest level of security by most RDBMS is
What is database collection?