1

I have an homework which should be submitted tomorrow I normaly know normalization concepts but in some questions I have difficulty. How should i normalize this to BCNF? Can you show the steps please?

R(A,B,C,D,E,F,H)

Functional dependencies are

A->D
AE->H
DF->BC
E->C
H->E

I found 2 candidate Keys which are AFH and AFE. Is this correct? I must be sure that my candidate keys are correct to continue to normalization.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.