What is Boyce Codd Normal Form ?

Question

Please can anyone expain me Boyce codd normal form or suggest some video tutorial or something to understand it well .

Answer 1

I used to refer these sites while studying Normalization
♦️https://beginnersbook.com/2015/05/normalization-in-dbms/
♦️https://www.gatevidyalay.com/database-normalization/

Hope this helps !!!

Answer 2

https://en.m.wikipedia.org/wiki/Boyce%E2%80%93Codd_normal_form?wprov=sfla1

Answer 3

Nithya Yamasinghe hi,
🍎 in database management system any table has following some properties by following some rules of DBMS this rules are known as Normalization rules which is used in creation of database tables

🍎 Normalization is the process of make your database compact & optimum. Normalization normally have 4 types but you can do normalization as many as complex your database...Conceptually it removes unnecessary dependencies & redundancy of your data from database

Generally, Normalization types are 1NF,2NF,3NF,BCNF(BOYCE CODE NORMALIZATION FUNCTION)...

After reaching this step of normalization your database already being optimum upto99%... no need to ho furthe

🍎 this rules can be define the forms in which the database is present. The database table can be in the form of 1NF, 2NF, 3NF and BCNF

🍎 BCNF is the most balanced form which is stand for Boyce Codd Normal Form
The below link can give you more information regarding this behavior

https://www.javatpoint.com/dbms-boyce-codd-normal-form

Answer 4

https://youtu.be/U1Y20cvhJIE
https://youtu.be/b39IhcO7qsA
https://www.youtube.com/playlist?list=PLeNFpOhruv2iM5EFv04SH4d84AO9WD2bA
This links of YouTube is pretty good and self explanatory

Have some 🍎 🍎 🍎 🍎

Answer 5

Infinity ♾️ Thank you very much 😊