Question: Consider the relation R = { G , H , I,J , K , L } and the following set of functional dependencies, which is
Consider the relation R GHI,JKL and the following set of functional dependencies, which is a minimal cover already.
GHI
GJ
IKL
a Find out all the keys of R
b Determine at which normal form is that table.
c Decompose R into second normal form relationsif not in NF Make sure the decomposition is lossless!
d Decompose R into third normal form relations if not in NF Make sure the decomposition is lossless!
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
