Question

Consider the following relation R(W, I, N, D, Y) with the following conditions: WàI NàD DYàW WIàY a) Find all the key. Justify your answer. b) Find prime and non-prime attributes. Justify your answer. c) Classify functional dependencies. Justify your answer. d) Determine normal form for relation R. Justify your answer.

          Consider the following relation R(W, I, N, D, Y) with the
following conditions:
WàI
NàD
DYàW
WIàY
a) Find all the key. Justify your answer.
b) Find prime and non-prime attributes. Justify your
answer.
c) Classify functional dependencies. Justify your
answer.
d) Determine normal form for relation R. Justify your
answer.

Consider the following relation R(W, I, N, D, Y) with the
following conditions:
WàI
NàD
DYàW
WIàY
a) Find all the key. Justify your answer.
b) Find prime and non-prime attributes. Justify your
answer.
c) Classify functional dependencies. Justify your
answer.
d) Determine normal form for relation R. Justify your
answer.

Added by Rosario V.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Amany Waheeb

Step 1

From the given conditions, we can see that the attributes W, I, N, D, and Y are all involved in some form of functional dependency. One possible key is {W, I, N, D, Y}, as it includes all the attributes in the relation. This key can be determined by observing Show more…

Show all steps

Thanks for your feedback!

Consider the following relation R(W, I, N, D, Y) with the following conditions: Wai NaD DYaW WIaY a) Find all the keys. Justify your answer. b) Find prime and non-prime attributes. Justify your answer. c) Classify functional dependencies. Justify your answer. d) Determine the normal form for relation R. Justify your answer.