Describe an example insertion, update, and delete anomaly
What will be an ideal response?
An insertion anomaly forces you to enter data about two entities when you only have data on one entity.For example, you cannot add a new employee without having an order that the employee fulfilled. A deletion anomaly forces you to delete two different pieces of datawhen you only want to delete one piece resulting in information loss. For example, you delete an erroneous order and you are forced to also delete the only instance of a particular product. Thus, you lose the information for that product.An update anomaly forces you to change data in multiple rows. For example, an employee needs to change their last name and you are forced to change that last name for every order that that employee has fulfilled.
You might also like to view...
The OpenOffice Writer ________ feature allows for the creation of form letters
A) Mail Merge B) Data Source C) Record Changes D) Main Document
A(n)________ is used to mark the end of an SQL statement
A) pound sign (#) B) asterisk (*) C) exclamation mark (!) D) semicolon (;)