Normalization & Functional Dependencies

Numerical answer

Single correct

• AReflexivity, Augmentation, and Transitivity
• BReflexivity and Augmentation
• CTransitivity
• DAugmentation and Transitivity

One or more correct

• AThe relation $team$ is NOT in BCNF.
• BThe relations $t1$ and $t2$ are in BCNF.
• CThe decomposition constitutes a lossless join.
• DThe relation $team$ is NOT in 3NF.

One or more correct

• AR1 is in 3NF
• BR2 is in 3NF
• CR1 is NOT in 3NF
• DR2 is NOT in 3NF

One or more correct

• A$(X, Y) \to (Z, W)$ implies $X \to (Z, W)$
• B$(X, Y) \to (Z, W)$ implies $(X, Y) \to Z$
• C$\left((X, Y) \to Z \text{ and } W \to Y\right)$ implies $(X, W) \to Z$
• D$(X \to Y \text{ and } Y \to Z)$ implies $X \to Z$

Numerical answer

Single correct

• A$D_1$ is a lossless decomposition, but $D_2$ is a lossy decomposition.
• B$D_1$ is a lossy decomposition, but $D_2$ is a lossless decomposition.
• CBoth $D_1$ and $D_2$ are lossless decompositions.
• DBoth $D_1$ and $D_2$ are lossy decompositions.

Answer key coming soon

One or more correct

• A$PS \to T$
• B$R \to T$
• C$P \to R$
• D$PS \to Q$

Answer key coming soon

Single correct

• A$R$ has a nontrivial functional dependency $X \to A$, where $X$ is not a superkey and $A$ is a prime attribute.
• B$R$ has a nontrivial functional dependency $X \to A$, where $X$ is not a superkey and $A$ is a non-prime attribute and $X$ is not a proper subset of any key.
• C$R$ has a nontrivial functional dependency $X \to A$, where $X$ is not a superkey and $A$ is a non-prime attribute and $X$ is a proper subset of some key.
• DA cell in $R$ holds a set instead of an atomic value.

Answer key coming soon

Single correct

• ABoth I and II
• BI only
• CII only
• DNeither I nor II

Single correct

• ASchema I
• BSchema II
• CSchema III
• DSchema IV

Single correct

• AS1 is TRUE and S2 is FALSE.
• BBoth S1 and S2 are TRUE.
• CS1 is FALSE and S2 is TRUE.
• DBoth S1 and S2 are FALSE.

Single correct

• A3
• B4
• C5
• D6

Answer key coming soon

Single correct

• Ain 1NF, but not in 2NF.
• Bin 2NF, but not in 3NF.
• Cin 3NF, but not in BCNF.
• Din BCNF.

Answer key coming soon