Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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


Please Help Members By Posting Answers For Below Questions

What is a database lookup?

1039


what is transaction state, buffer management, shadow paging

3378


What is database client?

956


How do you connect to a database?

1050


Which database is best to store images?

987


What does specialization in DBMS mean?

1097


Display the employees whose salary is less than average salary.

1010


what is tkprof tool and how it is used???

2771


What is the relationship that exists inside in E-R diagram?

1040


What is odm database?

942


Is data lake a database?

917


What is the difference between oracle and MS Access?

1019


can we delete autodiff back up that we have set through sql server agent.

2145


HOW WE PASS PARM PARAMETERS TO CL VARIABLES FROM RPGLE?

2584


What is a Transformation?

970