Chapt.6 - Normalization

___means inconsistency that occurs in the relational table during the operations performed on the table.

• Data integrity
• Data anomaly

• Data redundancy

The different types of data anomalies are:
[Select all that apply]

• Insertion Anomaly

• Selection Anomaly
• Deletion Anomaly

• Update Anomaly

When it is not possible to add data to a database because the required fields are missing or because the data is incomplete, it is called ___ anomaly.

• insertion
• update

• deletion

Deletion anomaly can be solved by

• normalizing the database
• ignoring the deletion anomaly
• denormalizing the database

Which type of anomaly can result in the unintentional loss of data?

• Deletion

• Insertion

• Update

___anomaly can result in inconsistencies or errors.

• Update

• Delete

• Insert

A reason why null values might be introduced into a database.

• Missing or unknown data
• Data inconsistency
• Data duplication
• Data corruption

What is the role of normalization in the database design process?

• Normalization helps in organizing data in a database.
• Normalization ensures data consistency in a database.
• Normalization improves data security in a database.
• Normalization helps in eliminating redundancy and improving data integrity.

The process by which a table is changed from a higher-level normal form to a lower-level normal form, usually to increase processing speed.

• normalization
• optimization
• aggregation
• denormalization

Which of the following is NOT a characteristic of normalized database?

• Each row/column intersection contains a group of values

• No data item is unnecessarily stored in more than one table

• Each table represents a single subject

• All non-prime attributes are dependent on the primary key