Question: Consider a relation $R$ with 5 attributes $M, O, N, E, Y$. You are given the following dependencies: $$ begin{array}{1} mathrm{OY} ightarrow mathrm{M} mathrm{ON}

Consider a relation $R$ with 5 attributes $M, O, N, E, Y$. You are given the following dependencies: $$ \begin{array}{1} \mathrm{OY} ightarrow \mathrm{M} \ \mathrm{ON} ightarrow \mathrm{E} \ \mathrm{EY} ightarrow \mathrm{N} \end{array} $$ Its candidate keys are $\{(\mathrm{MO}, \mathrm{Y}, \mathrm{E}), (\mathrm{0}, \mathrm{N}, \mathrm{Y})\}$. Read the following three questions carefully and choose the correct option by entering only $\mathrm{i}$, ii, iii, or iv. 1. Which of the following is a non-prime attribute for the relation $R$ ? i. M i. $\mathrm{E} $ iii. Y iv. $\mathrm{N} $ 2. Which of the following is true about the given functional dependencies in the relation $R ?$ i. All of the functional dependencies are not So Bad, except Oy $ ightarrow$ M. ii. $0 Y ightarrow M$ is a Very Good FD iii. $\mathrm{ON} ightarrow \mathrm{E}$ is a Very Bad FD iv. EY $ ightarrow \mathbb{N}$ is a Bad FD 3. Which of the following is the normal form of the relation $R$ ? i. Third normal form ii. Second woemal form ii. Boyce-Codd normal form iv. Fins noemal form CS.VS. 1168||
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
