DB EXAM

What is the main purpose of normalization in database design?

• To reduce the number of tables in a database

• To eliminate data redundancy and undesirable anomalies

• To increase the storage space required by tables

• To simplify the relational schema structure

Which of the following is an example of a data anomaly?

• Redundant data entry

• Missing data

• Inconsistent data after updates

• All of the above

Which of the following is NOT a type of data anomaly?

• Update anomaly

• Deletion anomaly

• Insertion anomaly

• Merge anomaly

.

• .

• .

• .

• .

.

• .

• .

• .

• .

In First Normal Form (1NF), what do we mean when we say that each row and column must have only one value?

• Every column must have a unique value

• Each row can have multiple values in a single column

• Each row can have multiple values in a single column

• You can have repeating groups, but no empty cells

Which of these is true about Second Normal Form (2NF)?

• It removes repeating groups and ensures no non-key attribute depends on the primary key

• It makes sure all non-key attributes fully depend on the whole primary key

• It eliminates issues with transitive dependencies

• It ensures that every row only has one number in each column

In Third Normal Form (3NF), which condition needs to be met?

• The table must be in 1NF and 2NF, and there should be no transitive dependencies

• All non-key attributes must depend on the primary key

• There should be no repeating groups in the table

• Every column should only have numeric values

What does it mean if a table is in Unnormalized Form (UNF)?

• The table uses only primary keys

• The table is already optimized

• The table contains repeating groups and multivalued fields

• The table uses foreign keys correctly

A transitive dependency occurs when:

• One column depends on a composite key

• A non-key attribute depends on another non-key attribute

• A key determines another key

• All columns are functionally independent