current community

your communities

more stack exchange communities

Stack Exchange
tour help
Take the 2-minute tour ×
Programmers Stack Exchange is a question and answer site for professional programmers interested in conceptual questions about software development. It's 100% free.
up vote 0 down vote favorite

I currently have a MySQL Relational Database with a users table with the following attributes:

  • ID (Primary key)
  • Name
  • Username (Unique)
  • Password
  • Email (Unique)
  • Description
  • Profile Picture File Path

I am really struggling with the normalization of the user's information since username and email are unique. Is this table normalized, if so, is it BCNF? or 3NF?

share|improve this question
    
What you describe is a typical user's table. I don't know if I'd go any further with it unless you had a good reason that you need it to be more complicated. –  GrandmasterB Apr 20 at 17:12
    
Ok, it seems it would be best to keep it simple. Thanks! –  flizana Apr 20 at 17:19

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.