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 ole db used for?

976


What is replicaset?

957


What is database client?

973


What is a Transformation?

983


What is a database string?

908


diff b/w inter process and in process

2029


if i want to display the name of students such that to which city they belong must have count greaer than two

2184


Explain alternate key?

1031


How default key is different from primary key?

1003


What is the concept of Virtual field?

2016


Why do we need distributed database?

953


What are the concurrency problems a database faces?

1005


How many indexes can be created on a table?

1103


A lowest level of security by most RDBMS is

1117


What is database collection?

972