I understood all the three normal forms which comes before BCNF but when it comes to the BCNF i am finding it extremely confusing and difficult and over the net also i found no good tutorial on it. Can any one explain what to do in order to make relation in BCNF form precisely ?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
Here's how it works:
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
BCNF fixes a minor flaw in 3NF
2NF and 3NF talk about non-key attributes:
BCNF tidies up intra-key attributes. It requires (in 3 different ways):
As the various tutorials say, you probably don't need it..