Monday, 5 January 2015

Decomposition into BCNF - Examples

Normalization Examples / Decomposition into BCNF tables / How to decompose a table into BCNF compliant table? / BCNF decomposition examples


Here, I have listed some examples and links for decomposing a relation into a perfect BCNF relation.

1. Simple and neatly explained example of BCNF decomposition - Click here.

2. Method for normalizing a relation to BCNF based on functional dependencies. Steps are explained. Click here.




No comments:

Post a Comment

SQL exercises for beginners one

SQL Exercises for Beginners / Simple SQL Exercises with Answers / Solved SQL exercises / SQL solved exercises with simple conditions / So...