Interested to Buy Any Domain ? << Click Here >> for more details...
What are the three types of anomalies in database and
Explain?
- 9 Answers
- 94147 Views
- I also Faced
- E-Mail Answers
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 the difference between primary and candidate key?
what is tkprof tool and how it is used???
When should you not use firebase?
A lowest level of security by most RDBMS is
What are different types of resources?
What is the use of default key?
WHAT IS NEED BY METION DATFMT AND TIMFMT IN H-SEPICITION IN RPGLE?
What is the DIF format and when we will use in teradata
What advantages does DBMS have over traditional file systems?
Given a table Employee which has columns name and salary, write an SQL query to find the employee with the second highest salary.
1. How to test Database? Please, give me all details for "SQL,Msaccess, Mysql Database? 2.For which functionalities database used? 3.How to convert Guest to Admin by Mysql database?
What is a database example?
What is database server and how it works?
Explain transaction manager?
What are database connection details?
