Hi frinds.
What is normalization and what is BCNF.
Please give me brief description with simple example.
Please help me.
Thanks & Regards
Jasonmark
jasonmark238
0
Newbie Poster
Recommended Answers
Jump to PostDatabase 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 …
All 2 Replies
mshauny
25
Junior Poster in Training
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.
AARTI SHRIVAS
2
Posting Pro in Training
follow this link
http://www.aliencoders.com/content/basics-normalization-examples
and BCNF is a type of normalization like others first NF, second NF, third NF,fourth NF,BCNF and last is fifth NF.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.