Lec 13: BCNF in DBMS | Boyce Codd Normal Form | Normalization in DBMS

In this lecture, you will learn about Boyce Codd normal form (BCNF) with example.
Rules and Requirements for a table to be in BCNF.


*******************************************

Connect & Contact Me:

*********************************************

More Playlists:

#dbms #dbmstutorials #normalization #jennyslectures
#bcnfindbms
#BCNFindbms
#whatisnormalizationindbms

[vaibhavjaviya]

your college professor should proud of you for your affords to everyone for teaching without any selfishness

[hwmeng]

simply speaking, you are better than my professor...you make me clearly understood in less than 30 mins, you save my life

[katnew]

Jenny I've watched about 10 of your videos today, all have been amazing! You are the best! Thanks from Australia

[amasiancovers]

17:53, it is not in 2NF right? Because A is a proper subset of the candidate key and it is determining BCDE, but D and E are all non prime attributes.Then how it can be second normal form?

[rishus]

Normalisation series has been awesome!

[themusicplanet]

proud of you ma, am.
yesterday i watched all your videos related to normalization, and I learnt so much from the videos, but when I entered to the exam hall and after reading the paper I felt shock because of the questions of normalization which were completely different from your playlist.
The question had tables and in your videos we cant see such tables to for normalization.

Regards

[Bhubaneswar_Sandha]

super se madam, i am a ETC student, left my study since 2012. no touch with engineering since then.. for nielit i applied and i really understood all dbms videos in one go only. you are awesome

[arinrahman]

1NF:
Each attribute should contain atomic values
A column should contai value from the same domain
Each column should have unique name
No ordering to rows and columns.
No duplicate rows.

2NF:
It must be 1NF
No Patial dependency in the relation (Partial dependency occurs when the left hand side of a candidate key points non-prime attributes)

3NF:
It is in 2NF
No transitive dependency for non-prime attributes
(To be non transitive and 3NF atleast one of these must be true: Either the left handside of funtional dependency is superkey or the right handside points to a prime attribute)

BCNF:
A relation is BCNF if it is 3NF
For each functional dependency there must be a super key

[NicksterNOC]

Thank you for getting me through my summer databases class Indian lady :)

[clebsonmachado]

Before, I went from 1FN to BCFN haha, grateful for the teaching. Hugs from Brazil

[IWILLROXU]

I can't pay you any fee. But I will never skip any of your Advertisements. This is how I gonna payback. Thank you so much. Much love from Sri Lanka <3

[wtkvljq]

Hi jenny's thank you for the lecture i understand very well but the last example the relation not 3NF i suppose because it isn't 2NF because D -->A it's partial dependencies (DB CK).excuse me of my English because I'm Palestinian.

[KhakiShow]

I'm learning different subjects just with help of you. I'm so thankful that you provided these videos.

[HamzaShahzadEB_]

Teachers on YouTube are far better than the teacher I have been seeing in my study life.

[satyamkarn]

17:27 here in the first relation A -> D which is violating 2NF rule so why is it checked there ?

[nagashayanreddy]

Thank you. It's very clear explanation.. I got a new method to check the Highest normal form from BCNF . Previously I used to do from 1st normal form...

[wpgctarbela]

well done mem, suggestion: if possible, then explain normalization along with normal forms by having an example of any organization.this will be beneficial for students and they will take more interest in your lectures.

[arijitbose]

Its not in 2NF(AB-> CDE is PA-> NPA which means it has partial dependency) then how can it be in 3NF??

[VishalThakur-hvqd]

I watched your video 3 hour before my exam bt after watching ur video i totally forget everything. u look gorgeous ma'am🙃.

[sreenadhmahavadi]

I used your lectures for my masters program, thank you