Anomalies Due to Particular Characteristics in Each, Essay

Open, View, and/or
Download this Document

Total Length: 464 words ( 2 double-spaced pages)

Total Sources: 1

Page 1 of 2

anomalies" Due to particular characteristics in each, they may involve errors and cause difficulties in maintaining the consistency of the data as well as requiring unnecessary updates.

To show why this is so, we will take each singly and provide examples:

Insertion Anomalies -- Giving the example of creating a database for employees: inserting a new employee tuple into EM P_DEPT, necessitates that we include in the database either the inclusive attributes of the department that the employee works for or the characteristic NULL if the employee is still between departments. All attribute values of the specific department must be entered correctly so that they are consistent with that department in other tuples of EM P_DEPT.

Stuck Writing Your "Anomalies Due to Particular Characteristics in Each," Essay?

View All Our Example Anomalies Due to Particular Characteristics in Each, Essay

Have A Custom Example Essay Written

This means constant revision and updating when any slight change occurs in any one of these instances. If even one instance is overlooked, the result is inconsistency.

2. Deletion Anomalies - In other databases, DEPARTMENT tuples are stored separately therefore deletion of one component will not affect others. However here, if we deleted an employee tuple from EMP_DEPT that happened to be the last employee hired by that department, all information concerning that department is lost from the database.

3. Modification Anomalies -- If one changes the value of one of the attributes of a certain department, one has to simultaneously update the tuples of all the employees who work in that department otherwise….....

Show More ⇣

     Open the full completed essay and source list


OR

     Order a one-of-a-kind custom essay on this topic


sample essay writing service

Cite This Resource:

Latest APA Format (6th edition)

Copy Reference
"Anomalies Due To Particular Characteristics In Each " (2012, October 03) Retrieved June 7, 2026, from
https://www.aceyourpaper.com/essays/anomalies-due-particular-characteristics-108434

Latest MLA Format (8th edition)

Copy Reference
"Anomalies Due To Particular Characteristics In Each " 03 October 2012. Web.7 June. 2026. <
https://www.aceyourpaper.com/essays/anomalies-due-particular-characteristics-108434>

Latest Chicago Format (16th edition)

Copy Reference
"Anomalies Due To Particular Characteristics In Each ", 03 October 2012, Accessed.7 June. 2026,
https://www.aceyourpaper.com/essays/anomalies-due-particular-characteristics-108434
   

Open, View, and/or
Download this Document
order custom essay example