Database Normalization Quiz

What is an example of a non-atomic value in the 'Subjects' column?

• Math

• Math, Science

• Science

• Art

What is the purpose of organizing database tables and relationships?

• To ensure data dependencies are properly enforced

• To make the database more complex

• To increase redundancy

• To decrease data integrity

In the given example, which attribute is dependent on the Subject?

• StudentID

• Instructor

• Primary Key

• Composite Key

Which of the following is NOT a subject listed in the Students Table?

• Math

• Science

• History

• Geography

Which subject is associated with Dr. Green in the Subjects Table?

• Math

• Science

• Art

• History

Which subject is taught by Dr. White according to the Subjects Table?

• Math

• Science

• History

• Art

Which of the following is a composite key in the original table before transformation?

• StudentID

• Subject

• Instructor

• StudentID, Subject

Which of the following is a key concept of the Second Normal Form?

• Atomic values

• Partial dependencies

• Composite keys

• Foreign keys

What is the relationship between Instructor and Subject in the original table?

• Instructor is independent of Subject

• Instructor is dependent on Subject

• Instructor is a primary key

• Instructor is a composite key

What does 1NF eliminate in the normalization process?

• Transitive dependencies

• Repeating groups

• Partial dependencies

• Redundant data