Normalization of Database Tables Quiz

What is the main purpose of normalization in database design?

• To increase data redundancy

• To make tables more complex

• To speed up every query automatically

• To reduce data anomalies and redundancy

Which of the following describes an insertion anomaly?

• Data changes require multiple updates

• Deleting a record removes unintended data

• Queries run slower due to joins

• Data cannot be inserted without the presence of other data

Which statement best defines a functional dependency (FD)?

• A relationship where a table depends on another table

• A way to reduce anomalies in a database

• A process of breaking a table into smaller tables

• A constraint where one attribute uniquely determines another

A table is in First Normal Form (1NF) if:

• It has no transitive dependencies

• Each non-key attribute depends on the whole primary key

• Each non-key attribute depends only on the primary key

• Each column contains atomic values without repeating groups

Which dependency must be removed to achieve Second Normal Form (2NF)?

• Transitive dependency

• Full functional dependency

• Composite dependency

• Partial dependency

A transitive dependency occurs when:

• A non-key attribute depends on only part of a composite key

• A key attribute depends on a non-key attribute

• Two primary keys depend on each other

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

What is the main drawback of over-normalization?

• Inconsistent data

• Too many anomalies remain

• Data redundancy increases

• Complex joins that may slow query performance

Given the table: Student(ID, Name, Subject1, Subject2, Grade1, Grade2). Why is it not in 1NF?

• It contains null values

• It has no primary key

• It contains transitive dependency

• It contains repeating groups/multi-valued attributes

Which statement describes a partial functional dependency?

• An attribute depends on the whole composite key

• An attribute depends on a non-key attribute

• An attribute depends on another table

• An attribute depends on part of a composite key

Why is Third Normal Form (3NF) often considered sufficient for business databases?

• Because it eliminates insertion anomalies only

• Because it is the highest normal form

• Because it ensures maximum query performance

• Because it reduces redundancy and anomalies while maintaining efficiency