Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
    
re-tagged as homework –  Stuart Blackler Dec 16 '12 at 13:22
    
@StuartBlackler meta.dba.stackexchange.com/questions/828/… –  dezso Dec 16 '12 at 16:09
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.