Chapter 3 Pop Quiz

Which of the following best defines normalization?

• The process of reducing data redundancy and improving data integrity

• The process of increasing the number of tables in a database

• The process of storing all data in a single table

• The process of duplicating records for faster retrieval

Which of the following describes Functional Dependency (FD)?

• A relationship between attributes where one attribute uniquely determines another

• A relationship where an attribute depends on two or more attributes

• A process to merge two tables into one

• A method for creating indexes in a database

Which of the following is NOT a type of normal form?

• First Normal Form (1NF)

• Second Normal Form (2NF)

• Third Normal Form (3NF)

• Fourth Normal Form (4NF)

What is Boyce-Codd Normal Form (BCNF)?

• An extension of 1NF

• A stricter version of 3NF that ensures no anomalies due to functional dependencies

• A method for denormalizing a database

• A process used in data warehousing

Which of the following problems does normalization help to prevent?

• Data redundancy and anomalies

• Faster indexing

• Query optimization

• Data encryption

In which normal form do all attributes contain atomic (indivisible) values?

• 1NF

• 2NF

• 3NF

• BCNF

What is the main requirement for a table to be in 2NF?

• It should be in 1NF and have no partial dependencies

• It should have only single-valued attributes

• It should have no transitive dependencies

• It should be in BCNF

Which of the following best defines transitive dependency?

• A situation where one non-key attribute depends on another non-key attribute

• A dependency where one key attribute determines another key attribute

• A direct dependency between primary keys

• A one-to-one relationship between entities

What is an ERD primarily used for?

• Representing database schema graphically

• Encrypting database tables

• Writing SQL queries

• Storing raw data

What is the main reason for removing transitive dependencies in a database?

• To increase storage space

• To improve query performance

• To eliminate redundant data and anomalies

• To allow multiple users to access the database