Database Normalization and Dependencies Worksheet

3rd Normal Form (3NF) means that all non-key columns in a table are only associated with the primary key.

• True

• False

We know this is a time anomaly, therefore we decide to:

• Add another column in a different table to keep track of the current price

• Add a column to a different table to keep track of the current price and remove the column with changing prices.

• Create a new table for both a current fee and a past fee

• Do nothing it will work itself out ... in time. ;)

When looking for partial functional dependencies we look in the following tables

• Tables with a single field primary key

• Tables with a composite primary key

• Tables with a foreign key

• Tables with both a single field primary key and a foreign key

We remove derived dependencies in...

• 1NF

• 2NF

• 3NF

• Derived dependencies are never removed

If a non-key attribute depends on another non-key attribute in the same table this is referred to as a

• Partial Functional Dependency

• Functional Dependency

• Transitive Dependency

• Composite Dependency

If a non-key column can be determined by part of a composite primary in the same table this is referred to as a(n)

• Partial Functional Dependency

• Functional Dependency

• Transitive Dependency

• Composite Dependency

The process of structuring a relational database to reduce data redundancy and improve data integrity is called

• DRT (data redundancy technique)

• Normalization

Which process helps in achieving Data Integrity and Anomaly Correction?

• Data Integrity

• Anomaly Correction

• Normalization

Poor database design may lead to

• Insertion anomalies

• Deletion anomalies

• Modification anomalies

• Time anomalies

• All of the answers are correct

When values in a database are repeated unnecessarily this is called

• data redundancy

• data integrity

• data definition

• none of the above