Question: Consider the relation R = { G , H , I,J , K , L } and the following set of functional dependencies, which is

Consider the relation R={ G,H,I,J,K,L} and the following set of functional dependencies, which is a minimal cover already.
GH->I
G->J
I->KL
(a) Find out all the keys of R.
(b) Determine at which normal form is that table.
(c) Decompose R into second normal form relations(if not in 2NF). Make sure the decomposition is lossless!
(d) Decompose R into third normal form relations (if not in 3NF). Make sure the decomposition is lossless!

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!