Interested to Buy Any Domain ? << Click Here >> for more details...
What are the three types of anomalies in database and
Explain?
- 9 Answers
- 94493 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 are the concurrency problems a database faces?
List some advantages of dbms.
What is the database url?
WHAT IS CARDINALITIES OF JOIN?
Why merge statement is used inside the database?
Explain entity type?
Why do we need distributed database?
Which is the best graph database?
How much does it cost to build a database?
Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool
What is aws documentdb?
What are different types of resources?
Which database is best to store images?
what is data access layer?
hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com
