Question

34

Inconsistent data in a relational database is most likely a result of the:

	a.	Delete anomaly
	b.	Update anomaly
	c.	Insert anomaly
	d.	None of the above

Answer 1

There are three types of anomalies that occurs when the database is not normalised. Namely

1. Insert anomaly

2. Update anomaly

3. Delete anomaly.

Insert anomaly is a result of inserting data in a record that does not exist at all.

Delete anomaly is a result of deleting partial data but some part is left undeleted because of unawareness or data is saved somewhere else.

Whereas update anomaly is a result of scattered data which is not linked to each other properly. This leads to inconsistent data.

Therefore answer is,

Inconsistent data in a relational database is most likely a result of the

b. Update anomaly.