What is the primary goal of database normalization?

To reduce or eliminate data redundancy.

True or False: A functional dependency is denoted by an arrow (→).

True.

Fill in the blank: A relation is in ______ if it contains composite or multi-valued attributes.

First Normal Form (1NF)

Which of the following is a property of a non-trivial functional dependency? A) X → Y is trivial if Y is a subset of X B) X → Y is non-trivial if Y is not a subset of X C) Both A and B D) None of the above

B) X → Y is non-trivial if Y is not a subset of X

Riddle: I eliminate redundancy and help avoid anomalies, but I require a careful design of relations. What am I?

Database normalization

In which normal form does a relation not have any transitive dependency for non-prime attributes?

Third Normal Form (3NF)

True or False: A relation is in Boyce-Codd Normal Form (BCNF) if for every functional dependency, the left-hand side is a super key.

True.

Fill in the blank: A relation is in ______ if it is in 3NF and has no non-trivial multivalued dependencies.

Fourth Normal Form (4NF)

What is the highest normal form that a relation can achieve if it contains partial dependencies?

First Normal Form (1NF)

Which functional dependency property states that if X → Y and Y → Z, then X → Z? A) Augmentation B) Reflexivity C) Transitivity D) Union

C) Transitivity