1,105,578 Community Members

What is BCNF

Member Avatar
Newbie Poster
11 posts since Jan 2013
Reputation Points: 0 [?]
Q&As Helped to Solve: 0 [?]
Skill Endorsements: 0 [?]

Hi frinds.
What is normalization and what is BCNF.
Please give me brief description with simple example.
Please help me.

Thanks & Regards

Member Avatar
Junior Poster in Training
69 posts since Jan 2010
Reputation Points: 25 [?]
Q&As Helped to Solve: 7 [?]
Skill Endorsements: 0 [?]

Database normalization is the process of organizing the fields and tables of a relational database to minimize redundancy and dependency. Normalization usually involves dividing large tables into smaller (and less redundant) tables and defining relationships between them. The objective is to isolate data so that additions, deletions, and modifications of a field can be made in just one table and then propagated through the rest of the database via the defined relationships.
source : Wikipedia

BCNF is just a normalization form used in Database normalization.

Find examples

Member Avatar
Posting Pro in Training
410 posts since Dec 2012
Reputation Points: 2 [?]
Q&As Helped to Solve: 38 [?]
Skill Endorsements: 3 [?]

follow this link
and BCNF is a type of normalization like others first NF, second NF, third NF,fourth NF,BCNF and last is fifth NF.

This article has been dead for over three months: Start a new discussion instead
Start New Discussion
View similar articles that have also been tagged: