Hi Guys

Not sure if this is in the right forum, but it is SQL based so I put it here.

Can anyone help me by telling me if there is an easy way to explain if a table is in Boyce Cod Normal Form (BCNF)

I am struggling with it and need to look at some tables and say if they are or not and why.

An example would be:

ProductCategory

ProductCategoryKey
ProductCategoryAlternateKey
EnglishProductCategoryName
SpanishProductCategoryName
FrenchProductCategoryName

I understood it ot mean if any of the items is not dependant on the key it isnt in BCNF ??

Apologies for appearing thick, I have had enough of Databases now... :P

G