Question: Consider the universal relation R = ( A , B , C , D , E , F , G , H , I, J
Consider the universal relation RA B C D E F G H I, J and set of functional dependencies FAB C; ADE; BF; FGH; DIJ Now answer the following.
If R not in NF give reasons, and decompose R into to NF If not in NF
Consider that if R is decomposed into RA B C D E; RB F G H and RD I, J check whether the decomposition is Lossless, and Dependency preserving.
For each test, both working and final answer are important. Not yes or no answers
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
