3. Databases

Database Design — Quiz

Test your understanding of database design with 5 practice questions.

Practice Questions

Question 1

Which schema stage describes the organization of data structures, tables, columns, and relationships in a way that is independent of any specific DBMS implementation?

Question 2

Which mapping strategy creates a separate table for the superclass and each subclass, allowing nullable columns in subclass tables to be minimized?

Question 3

Given a relation R(A,B,C) with a functional dependency A→B, which decomposition yields relations that satisfy Boyce-Codd Normal Form (BCNF)?

Question 4

Which index type is most efficient for range queries on a date column in a relational database?

Question 5

Which normal form addresses the removal of multi-valued dependencies to prevent redundant storage of independent attribute sets?