0

USER(userID, email, name, address, ...)

userID

  • primary key
  • incrementing bigint

email

  • unique identifier
  • can be modified by user

To me this seemed like a good idea, but then I started to wonder: does the uniqueness of 'email' violate the third normal form (3NF)?

0
-1

To extend the hole idea why index doesn't matter

A indexed filed onlys describes that every row is unique, but this doewsn'z means that it is dependend from other columns than the promary key

A relation is in third normal form if there is no transitive dependency for non-prime attributes

following this definition, it still stands an indexed email field is dependent on the primary key and does not depend on other columns it is non transitively dependent

Which means that it correspnds teh 3NF

0

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.