question archive Consider a relation R with 5 attributes M, O, N, E, Y
Consider a relation R with 5 attributes M, O, N, E, Y
Subject:Computer SciencePrice: Bought3
Consider a relation R with 5 attributes M, O, N, E, Y. You are given the following dependencies: OM-->N OE-->M YO-->E OM-->Y It's candidate keys are {(OE), (MO), (OY)}. Read the following three questions carefully and choose the correct option by entering only i, ii, iii, or iv. 1. Which of the following is a non-prime attribute for the relation R? _________________ i. M ii. E iii.O iv. N 2. Which of the following is true about the given functional dependencies in the relation R? ______________ i. OM--> N is Bad FD ii OE--> M is a Not So Bad FD iii. OY --> E is a Very Good FD iv. OM --> Y is a Not So Bad FD 3. Which of the following is the normal form of the relation R? _____________ i. First normal form ii. Second normal form iii. Third normal form iv. Boyce-Codd normal form
