Database Normalization Quiz

In the provided example, which employee is managed by Bob?

• Alice

• Charlie

• David

• None

What is the purpose of database normalization?

• To increase data redundancy

• To simplify database queries

• To reduce data redundancy and improve data integrity

• To create more tables

What is the primary focus of the Third Normal Form?

• Data redundancy

• Data integrity

• Transitive dependencies

• Query optimization

In the unnormalized table, which book has multiple authors?

• Learning Python

• Database Design

• Advanced SQL

• Java Programming

Which of the following is not a benefit of normalization?

• Reducing redundancy

• Enhancing integrity

• Increasing complexity

• Structuring data

Who is the author of "Learning Python"?

• John Doe

• Jane Smith

• Emily Turner

• Michael Brown

What is the category of the book "Learning Python"?

• Databases

• Programming

• Networking

• Mathematics

Which publisher is associated with the book "Learning Python"?

• Pearson

• O'Reilly

• McGraw-Hill

• Wiley

In the context of the document, what is dependent on BookID?

• Author

• Publisher

• Category

• Title

Which table would you find the PublisherID for "Database Design"?

• Authors Table

• Books Table

• Categories Table

• Publishers Table