title: Can anyone explain me 1NF, 2NF, 3NF, BCNF rules with a proper example?
body: <p>This is a common interview question. I faced one interview where the interviewer gave me one table and asked me tell him which normal form the table is in? If it's in ##NF, then normalize it to the next NF?</p>
  
  <p>I'm always get confused between these normal forms of database. 
  Can anyone explain to me these normal forms with a proper example of how each NF is modeled into table so it will help in my next interview?</p>