Data+ V1 Normal Forms Quiz

Submit

2. Which of the following is NOT a primary goal of normalization?

Eliminate data redundancy

Reduce anomalies during data modification

Increase query performance automatically

Ensure data integrity and consistency

3. A table contains ProductID, ProductName, CategoryID, and CategoryName. To meet 3NF, you should separate the category information into a different table. True or False?

True

False

Submit

5. Which scenario represents a table that meets 1NF but violates 2NF?

A table with a multi-valued attribute in one column

A table with a composite key where one non-key attribute depends on part of the key

A table where a non-key attribute depends on another non-key attribute

A table with repeating groups stored in separate rows

Submit

7. To convert a table from 1NF to 2NF, you must eliminate which type of dependency?

Transitive dependencies

Partial dependencies

Functional dependencies

Primary key dependencies

Submit

9. Which normal form is considered the minimum acceptable level for most relational databases?

1NF

2NF

3NF

BCNF

10. A table in Third Normal Form eliminates both partial and transitive dependencies. True or False?

True

False

11. Which normal form eliminates repeating groups and ensures all attributes are atomic?

First Normal Form (1NF)

Second Normal Form (2NF)

Third Normal Form (3NF)

Boyce-Codd Normal Form (BCNF)

12. Which of the following best describes a partial dependency?

A non-key attribute depends on part of a composite primary key

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

A primary key depends on a non-key attribute

A non-key attribute depends on the entire primary key

13. A table with a single-column primary key is automatically in 2NF if it is in 1NF. True or False?

True

False

14. Which normal form addresses transitive dependencies?

1NF

2NF

3NF

2NF and 3NF equally

Submit

16. Repeating groups in a table structure violate which normal form?

1NF

2NF

3NF

BCNF

17. A table contains EmployeeID, EmployeeName, DepartmentID, and DepartmentName. DepartmentName depends on DepartmentID, not EmployeeID. This violates which normal form?

1NF

2NF

3NF

No violation

18. Which of the following is a characteristic of First Normal Form?

All attributes must be atomic

No partial dependencies exist

No transitive dependencies exist

All non-key attributes are functionally dependent on the primary key

Submit

20. A table has a composite primary key (StudentID, CourseID) and contains a non-key attribute that depends on only StudentID. This violates which normal form?

1NF

2NF

3NF

No violation

Data+ V1 First Second and Third Normal Forms Quiz

1. Transitive dependency occurs when a non-key attribute depends on another ____ attribute.

2.

What first name or nickname would you like us to use?

2. Which of the following is NOT a primary goal of normalization?

3. A table contains ProductID, ProductName, CategoryID, and CategoryName. To meet 3NF, you should separate the category information into a different table. True or False?

4. Normalization reduces data redundancy and improves database ____ and integrity.

5. Which scenario represents a table that meets 1NF but violates 2NF?

6. A relation is in BCNF (Boyce-Codd Normal Form) if every determinant is a ____ key.

7. To convert a table from 1NF to 2NF, you must eliminate which type of dependency?

8. An attribute that contains multiple values in a single field violates ____ Normal Form.

9. Which normal form is considered the minimum acceptable level for most relational databases?

10. A table in Third Normal Form eliminates both partial and transitive dependencies. True or False?

11. Which normal form eliminates repeating groups and ensures all attributes are atomic?

12. Which of the following best describes a partial dependency?

13. A table with a single-column primary key is automatically in 2NF if it is in 1NF. True or False?

14. Which normal form addresses transitive dependencies?

15. A database table is in 2NF if it is in 1NF and has no ____ dependencies.

16. Repeating groups in a table structure violate which normal form?

17. A table contains EmployeeID, EmployeeName, DepartmentID, and DepartmentName. DepartmentName depends on DepartmentID, not EmployeeID. This violates which normal form?

18. Which of the following is a characteristic of First Normal Form?

19. Third Normal Form (3NF) requires that non-key attributes are dependent only on the ____.

20. A table has a composite primary key (StudentID, CourseID) and contains a non-key attribute that depends on only StudentID. This violates which normal form?