Shortened DB

What does 1NF (First Normal Form) in database normalization require?

• Each table cell should contain a unique table reference.

• Each table should have a single primary key.

• Each table cell should contain only atomic (indivisible) values and no repeating groups or arrays.

• Each table should be related to at least one other table in the database.

What is a requirement for a database table to be in 3NF (Third Normal Form)?

• The table must have a composite primary key.

• Non-key attributes must not depend on any other non-key attributes.

• All attributes must be functionally dependent on all candidate keys.

• The table must be in 2NF and all columns must be atomic.

Answer explanation

This means the table should be free from transitive dependencies.

What is a requirement for a database table to be in 2NF (Second Normal Form)?

• The table should have a primary key and no repeating groups.

• All non-key attributes must be fully functionally dependent on the primary key.

• The table should contain only atomic values and each row should be unique.

• The table should have relationships with at least two other tables in the database.

What does 4NF (Fourth Normal Form) primarily address in a database table?

• Elimination of all primary key dependencies.

• Removal of multi-valued dependencies.

• Ensuring all attributes are functionally dependent on the primary key.

• Decomposing tables to reduce the chance of data anomalies.

What is the key feature of a database table in BCNF (Boyce-Codd Normal Form)?

• It should be in 3NF and every determinant must be a candidate key.

• It allows no partial dependencies on a composite key.

• It should have no transitive functional dependencies.

• It must eliminate all multi-valued dependencies.

In database normalization, what is a transitive dependency?

• A situation where changing one non-key attribute forces changes to other non-key attributes.

• When an attribute is functionally dependent on a non-key attribute, which is itself functionally dependent on the primary key.

• A relationship where one attribute determines the value of another attribute in the same table.

• A dependency where an attribute depends on the entire composite key, not just a part of it.

What is a functional dependency in database design?

• When an attribute uniquely identifies another attribute in the same table.

• When a change in one attribute causes a change in another attribute.

• When an attribute's value is determined by another attribute or a group of attributes.

• When an attribute's value is dependent on the primary key of a different table.

What does partial dependency refer to in database normalization?

• When an attribute is dependent on only a part of a composite primary key.

• When an attribute is dependent on the whole primary key but not on any non-key attribute.

• When an attribute is partially dependent on both key and non-key attributes.

• When two or more attributes are partially dependent on each other.

What does BC stand for in BCNF?