I was convinced that what violated the first normation rule was having a multivalued column.

 id  name    friends
 1   'john'  'Maycon, Gabriel'

That has multiple names in the same column.

Compound columns don't violate the rule because they are atomic.

 id  name    localization
 1   'john'  'SP, Brazil'

That is not multivalued, it is just compound.

But now I read that just having a table with a primary key is enough to have the first normalization rule met.

What is correct?



Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.