Database Normal Forms Quiz

Storing the same data multiple times in a database.

• Inefficient Data Maintenance

• Non-Key/Transitive Dependency

• Lack Of Data Flexibility

• Data Duplication/Redundancy

A table is in this NF if it is in 1NF and all non-key attributes are fully functionally dependent on the entire primary key (applies to tables with composite primary keys).

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

The process of organizing data in a database to reduce redundancy and improve data integrity.

• Data Duplication/Redundancy

• Insert Anomaly

• Normalization (Database)

• Atomicity (in Databases)

The property of a column holding only indivisible values.

• Normalization (Database)

• Atomicity (in Databases)

• Third Normal Form (3NF)

• Data Duplication/Redundancy

A dependency where a non-key attribute depends on only part of a composite primary key.

• Update Anomaly

• Functional Dependency

• Partial-Key Dependency

• Non-Key/Transitive Dependency

A dependency where a non-key attribute depends on another non-key attribute, which depends on the primary key. (A -> B -> C)

• Data Duplication/Redundancy

• Partial-Key Dependency

• transitive/Functional Dependency

• Non-Key/Transitive Dependency

Inconsistency in data resulting from a partial update.

• Insert Anomaly

• Insertion Anomaly

• Delete Anomaly

• Update Anomaly

Inability to add data to a database due to missing information.

• Update Anomaly

• Integrity Anomaly

• Insert Anomaly

• Delete Anomaly