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...
What is your terminal type set to? What command did you use to get your answer?
What will be an ideal response?
The ____ defines the point from which a transformation occurs.
A. point of origin B. crosshairs C. open sequence D. starting point
In a flow chart, a(n) ________ shape indicates where a process is performed in the chart
A) oval B) circle C) diamond D) rectangle
If pt is declared as a pointer to a structure of type Employee, ____ refers to the idNum member of the structure.
A. (*pt).idNum B. *pt.idNum C. *(pt.idNum) D. (*pt.)idNum