Explain the three types of anomalies associated with database tables that have not been normalized.
What will be an ideal response?
The update anomaly is the result of data redundancy. If a data element is stored in more than one place, it must be updated in all places. If this does not happen, the data are inconsistent.
The insertion anomaly occurs when too much data is stored together-when vendor information is only stored with specific inventory items. Until items are purchased from a given vendor, the vendor cannot be added to the database.
The deletion anomaly is the opposite of the insertion anomaly-if a vendor supplies only one item, and the firm discontinues that item, all information on the vendor is lost when vendor information is only stored with specific inventory items.
PTS: 1
You might also like to view...
Two issues to consider with the computation required to use RSA are encryption/decryption and __________ .
A. time complexity B. trap-door one-way functions C. key generation D. asymmetric encryption padding
The first step in the software installation process is to ____________________ the files to your computer.
Fill in the blank(s) with the appropriate word(s).
If you type ________ in a field that is a Date/Time data type, the current date will be displayed
Fill in the blank(s) with correct word
Applications best suited for relational databases are those whose data can be organized in a two-dimensional table.
Answer the following statement true (T) or false (F)