For example , suppose there are 5 columns says A,B,C,D,E and combination of the columns A and B constitute the Primary key for this table.
Suppose, there is no transitive dependencies are existed in this table, but column C can determine the value of column B. In other words, the value of Column B is determined by the Column C then this table can not be in the Boyce – Codd Normal Form. To make this table in BCNF we needs to divide this table into two tables “table 1” and “table2” . The table1 will contains the following columns A, B, D,E where primary key is the combination of the column A and B and table2 will contains the two columns B , C where C will be the primary key.
Table 1 (Primary key :-A,B) Table2 (Primary Key :- C)
Thus every table satisfying the 3NF condition cannot be said to be in BCNF normal form but a table in BCNF will always be in 3NF form.
8 thoughts on “Boyce – Codd Normal Form (BCNF)”
guide me for mssql certification.
i want to do it but how? please guide me.
Is there any combination of linux and mssql for a good job in a reputed company?
can you tell me how to create stored procedure in sql server 2008 plz guide me step by step
Thanks for your valuable comments. For Stored procedures, below link will be useful to you
thanks for useful info
Great article. It will be helpful if you give an example table and illustrate the statement:
"olumn C can determine the value of column B. In other words, the value of Column B is determined by the Column C".
Its a great article.it will be help full to us who wants to learn the new things …
Theory & examples are very easy to understand. It will be very help full to me,all the articles are good,
Thanks to u
Thanks for your Valuable comments