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

[@vaibhavjaviya6100]

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

[@rddler9238]

Dude, thats efforts not affords, edit that shit, don't make fun of yourself.

[@RiteshPatil0403]

@Rapid Tech 👀 i know his attention

[@aanishas1925]

So true

[@This_truly_is_evil_era]

​@@rddler9238there is nothing wrong in making fun of urselves

[@lil_muffin_]

@@rddler9238 It wouldn't hurt to be a bit nice 😒

[@hwmeng4947]

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

[@plznerf3326]

Thanks!

[@katnew]

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

[@I619WILL619ROX619U]

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

[@Aditya_Parmar_Official]

19:44 D → A satisfies 3NF, but as D is a proper subset of a candidate key and A is a prime attribute, how does it satisfy 2NF?

[@rishus7938]

Normalisation series has been awesome!

[@shashwatjha9491]

yes true. Completely understood everything

[@durumarthu]

You were put on this earth to teach. My professor might as well speak a completely foreign language during lecture and I would gained the same amount of knowledge, which is nothing. Thank you for explaining the concepts so simply and step-by-step. I literally was laughing when I realized how simple this is because of the way you explained it. I hope we as your students and fans give you all the motivation you need to keep going. I will also be making a financial contribution to support your efforts and encourage everyone else who is benefiting to do so as well.

[@sanjana9599]

watching from Toronto, Canada studying for my university exam. I admire how beautifully you explain.

[@themusicplanet7084]

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

[@sai_durga-n4h]

super se upar........ 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

[@cmmsilva]

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

[@arinrahman8368]

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

[@popeyetech9634]

I think in bcnf in the second rule there are some differences we have to check super keys in LHS for those dependices which are in not trivial form....

[@popeyetech9634]

Apart from the last one thanks for your efforts....

[@KhakiShow]

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

[@amasiancovers4779]

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?

[@tiieej3950]

Proper subset of A is phie not A

[@vinayakrodd8837]

@@tiieej3950 A is candidate key but A determines D and E which are non prime that is why the relation is not in 2NF Also

[@vinayakrodd8837]

You are right

[@Aditya_Parmar_Official]

nope, A is subset of candidate key not proper subset. EXAMPLE proper subset of A,B,C are A,B,C,AB,AC,BC not A,B,C(its subset not proper subset) .....

[@HamzaShahzadEB_]

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

[@satyamkarn3277]

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

[@ManjuBala-wd8hf]

Same doubt

[@NicksterNOC]

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

[@anithapanneerselvam8473]

👍

[@techgatron7622]

this video teaches me lots of things about bcnf,3nf 2nf ... youre perfect teach. bests from TR

[@neva7227]

Clearly understood 1NF, 2NF, 3NF and BCNF, thank you

[@sreenadhmahavadi577]

I used your lectures for my masters program , thank you

[@nagashayanreddy7237]

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...

[@adnansarhan7184]

22:35 CDE is not a primary attribute, How is it 3NF?

[@praneeth22v]

Iam From Italy... watching ur vdeo😍 It helped me alot in xams

[@wpgctarbela6585]

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.

[@softtechtutorials9609]

Your way of teaching is very good.

[@mitul22br]

13:26 Can't we reduce BC -> ACE to B->AE? So then the candidate keys would be A and B.

[@uniqueversalunicorn2412]

yeah, I think the same

[@sedighehfazli1525]

I am crying watching this video , thank youuuu, it helps a lot ❤

[@eagle_shadow6665]

You teach very well and in simple way 👌😊🤗

[@zoe-mv5vk]

thank you sister .you made my dbms studies easily.I request to you prepare a videos of data mining play list

[@uniqueversalunicorn2412]

At 13:35, BC -> AEC ; Then as per "Augmentation rule" we can cancel out C on both sides... and the resultant is B -> AE; Then as per "Decomposition rule" we can say B -> A & B -> E.... Then the "Closure of B" should be {B, A, E, C, D}... Then B would become a Super key & a Candidate key as well.... Hence the Ck will be A, B..... And not C right?? Then the Prime attributes will be A & B. Non-prime attribute will be C.

[@vuruvwzlksz]

21:50 Why does the BCNF carry over to the third normal form? Why does the left hand side being a super key imply there is no transitivity or partial dependencies?

[@diegofabianledesmamotta5139]

The transitivity that the 3NF talks about occurs when there is a FD from a non prime attribute (NP att) to another NP att. BCNF says that in any FD the left hand side must be a superkey, so is not possible for a schema to be in BCNF and have a transitive dependency at the same time.

[@diegofabianledesmamotta5139]

Partial dependency is a dependency with a part of a superkey that is not a superkey in the left hand side. BCNF says left hand side is always a superkey.

[@VishalThakur-hv6qd]

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

[@aditidump]

at 13:17, BC->ACE by augmentation property can we say that B->AE?

[@uniqueversalunicorn2412]

yes, you are correct...

[@سيفالدولةواثقخضرعباسسيفالدولةو]

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.

[@alexmercerind]

Hmmmmmmmmmm intresting

[@Broken_mirror_yt]

@@سيفالدولةواثقخضرعباسسيفالدولةو Now you are in safe 🙂

[@lockdownbatch8751]

Timestamp 16:30..... if BC determines ACE then BC intersection ACE will be C so this is not non trivial fd so why to check for 3NF or BCNF

[@TECHG0806]

yea that's my point too. i too got confused there!

[@hemantjha680]

@@TECHG0806 me to

[@itspurelypassionate]

Thanks Mam. Because of you i was able to understand everything!

[@yashsawant3477]

Thanks for your total DBMS Playlist Because Of This I was clear my all concept.

[@ayeshabilal275]

Slam from Pakistan watching your videos u deserve a best teaching award 🥰🥰

[@godakartik8110]

tere desh mei dete kya??

[@stutijha4476]

Thankyou so muchh mam , u really a good teacher 💜💜.u clear all doubts of (1,2,3,BC)NF .

[@YogeshSharma-nu2of]

👍

[@MarathonMombie]

Your videos are so incredibly helpful. Thank you!

[@ashishtayade047]

Thank you mam very nice gide & very nice explain boyce codd normal form teaching information video.👍

[@wreckereditz8104]

Thanks For Saving My Life ❤

[@MonkeyD.3892]

Thanks Mam Great Video 🙏🙏

[@repallemahendrababu9030]

MAM..Your Explanation very Nice...

[@_the__hash_24]

I learn normalization from the other you tube channel but in everytime I'm getting confuse , after watching your videos all doubt about the normalization is solved.

[@rakeshpanda7236]

11:20.... CKs are A,B,C and proper subset of each CK is null. PA ={A,B,C}. So, NPA =null. So, doesnt this mean PD exist as Proper subset of CK ---> NPA ???? Can u pls brief out Madam?

[@martinvisualstudio1567]

no doubts your an awesome tutor :)

[@akshaynagarevlogs7979]

mam apka scheduled jara share karo hume....during your struggle time.....supremly talented ....not only that but how to make the concept understanfdi in proper way......hats offf mam..suoerb

[@peddintikarthik6206]

You are more better than my sir Mam I love you as letcher 🤗😋

[@sureshtech2696]

Super teaching skills you are my ideal thank you mam❤️👍

[@drashti4026]

simplicity with more clarity 😎👍🤌

[@harshpandey8159]

Awesome teaching ma'am❤️

[@toshikacvedi710]

14:58 A -> BCDE Means A -> E A is candidate key also. Here P.A. -> Non P.A. So how can it be in 2NF. I got that it is in 3NF . So acc. To that it will be in 2NF by default. But if we doesn't consider 3NF , how can it be in 2NF

[@shahzarkhan5421]

You got that wrong. Let me explain, For 2nf you must check (Proper subset of Candidate key -> Non prime attribute). Here proper subset of Candidate key {A} is ∅ not A itself.

[@toshikacvedi710]

@@shahzarkhan5421 oky okyy...thnk u

[@vedanshsharma1156]

@@shahzarkhan5421 thanks

[@safiullahakbar4971]

At 15:01, mam you are checking only whether the left hand side is super key or not but for BC->ACE, it is not non trivial FD as BC intersection ACE {}, so why would we check whether the LHS is super key since it is not non trivial FD?

[@AVALACHAITANYA]

Beauty with Brain🙇‍♂️

[@gin1954]

17:48 here BC is a candidate key and as per 2NF proper subset of CK -> non prime attributes here proper subset of BC is B and C from FD BC -> ACE which implies B -> AE which again implies B -> A and B -> E if we consider B -> E here E is non prime attribute and B is proper subset of BC that means its not in 2NF why did u say its in 2NF??

[@SuperOpposum]

Jenny is the reason I'll have a bachelors in CS

[@drsheemu]

Ma'am please check last question...in that D determines A in which right hand side is prime attribute...but u have checked only left side...so it is in BCNF

[@lukskywaker]

Amazing teacher.... thank you

[@JppinaPinaZep1803]

Thank you for your content. Keep up!

[@RahulYadav-kk3cl]

@19:34 mam,you have declared DB as super key,so can you mam please elaborate how DB can be super key in this situation.

[@jagadeeshmandala4097]

Db is not a super key at all.. But she said it is a candidate key.. How it's possible? 😕🥺

[@redrose5950]

From DB You will get DB because of reflexivity, and from the dependency D - - >A, you will get DBA, Now you have DBA, so from AB which you have there is a given dependency AB - - > CDE, so finally you will GET DB-> DBACE

[@popeyetech9634]

@@redrose5950 correct

[@popeyetech9634]

Ab-->>>cde i think it is not non trivial functional dependices so there is no need to check left hand side as a super key...

[@Mihiret468]

I am a blank beginner for the course, but thanks to you ma'am, think I get the idea, what a super instructor!!! But to proceed my study , I couldn't find the video of 4NF & 5NF, could you help please?

[@thismakesnosense4815]

oh wow there's 4 and 5nf too? fml

[@donator5724]

@@thismakesnosense4815 6nf is there as well. But nf's beyond 4 are used rarely in system design.

[@thismakesnosense4815]

@@donator5724 Hello fellow earthling thank you for replying but I'll have you know that I'm done with my dbms end sem exam for now and I won't be looking back on said subject unless I'm held at gunpoint. Have a nice day ahead!

[@ThotaNagasudha]

thank you so much mam for you lectures

[@arijitbose1436]

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

[@saikrishna7509]

m Ma'am the way you say till then bye bye take care is cool and nice

[@jarrett1159]

This is insanely helpful

[@sarveshIASaspirant]

Tomorrow my exam and today i am here

[@anjandey6089]

history repeats itself

[@Said9967]

Hi Jenny, please can you explain, in case I have a data set in form of a table with 100 dimensions(Attributes), is there any shortcut in order to find all functional dependency or I have to do it manually ? thanks

[@franciscorodriguez-zb8uq]

13:17 B can determine a , c and e right? Mistake?

[@chalikieeswar3907]

Mam,why don't you do the videos on 4NF and 5NF

[@Amit-fq9cf]

thank you ❤

[@PRO----OP_____GOD]

I know already boyce codd i dont know why i am watching this video till end 😁😁

[@sanjitkumarmahato4039]

Hello Mam I have been watching your videos on DBMS its good and understandable ...but my problem or rather i could say question is that ...you are taking the relation(table) in the format of A,B,C,D etc as attribute and making some functional dependency on them that why it is easy to understand but when i create a real database and tables i unable ti find the functional dependency . How I will find functional dependency from the real database so that i can solve the normalization problems . please mam make separate video on that so that it would be easy for us to find the redundancy and anomalies and we can normalize the table. Thank you in advance.

[@shashwatjha9491]

For real life database just look at the attributes how are they relating for eg pincode -> state and country. Hence you know the FD now. It is similar to the process of how you decide a primary key for the table just think of what is the repeating part and how can i remove it (Think of that key in my eg pincode and repeating data is that of state and country)

[@turanmertduran2974]

very helpful vıdeo, thank you Mam!

[@turanmertduran2974]

I agree!

[@turanmertduran2974]

I agree too!

[@kiranparajuli6724]

I think X --> Y should be a trivial functional dependency where X is a super key to be a BCNF. Not non-trivial FD.

[@Santoo2207]

BC->ACE is not a non trivial function so directly we can say it is not in BCNF. Can we mam??

[@java_shaileshkushwaha878]

bcnf statement say every non-trivial fictional dependency x-->y X must be a super key But your que Bc->ace == bc->a and bc->c and bc->e we would only check 1st and 3rd fictional dependency bc->c is not consider

[@djkrish1072]

Ravindra Babu Ravula sir or Jenny Ma'am who's the best? According to me both are best. Ma'am if you were my college lecturer pakka I would have 100% attendance and definitely I would be the topper of my batch..!

[@anandms7537]

Yes I don't know why in college we common students are not getting like this faculties, if I would have got I would have not miss single lecture

[@namansandilya4520]

Ma'am please upload video on decomposition. Thanks

[@santoshtimilsina1092]

in 18:00 bc is a candidate key and it is determining ace? what about this?

[@princebhardwaj9725]

Beauty with Brain

[@umerbajwa4108]

it's like my childhood teacher teaches me. :)

[@franciscorodriguez-zb8uq]

Closure of a should be c d e right? 19:04

[@jacobfrye3658]

Didi aap kamal ho... humare clg me sab tatti hai. You are Godddddddddd

[@loyalmusic6033]

Mam in previous vedio you told that in 3nf if there are any non prime attributes so this would not satisfy the 3nf. So as per this rule in this qstn there are 2 non prime attributes so it is not satisfying the same 3nf rule then how can you write here that it is satisfying 3nf and the highest form is 3nf. Mam please clear my doubt plss You are the best teacher ever I found Thanks ☺☺

[@Gezshtech]

waooo thank u mam to ur ttral help

[@CaptainCoder1]

Hi learners can anyone resolve my this doubt! As we learnt that for a Relation to be in 2NF it has be in 1NF first then it should satisfy NO Proper subset of ck determines NPA test. And a Relation to be in 3NF it has to be first in 2NF and then there should not be any NPA --> NPA FD and for a Relation to be in BCNF it has be first in 3NF and all determinants must be super key. In the Lecture Mem started from BCNF test and she was telling if all determinants of all non-trivial FD are super key then it is sufficient to tell it is in BCNF, so does it mean ? we don't have to check 3NF test here, similarly for 3NF and 2NF. Thanks for your help in Advance !!!!

[@dwaipayan3086]

for ab->cde a and b are prime attributes so is ab prime attribute?

[@niteshsharma7602]

Mam, can u make the playlist for Theory of Computaion subject?

[@rohittechlife6415]

Try knowledge gate for theory of computation and neso

[@Rahulkumar-sd4pn]

follow neso academy for this

[@najialaaraj4144]

you are a legend

[@aminul.islam.]

Thank you ma'am

[@drap_on_the_track]

Ma'am what do mean by overlapping of candidate key? I did not understand that example what ever you had explained in the video.

[@HendersonHarrisson]

Please do a series on Transactions of DBMS please.

[@shubhamshiketd4256]

While teaching you are very strict about the concept, but i think you are very Slient in real life, great respect towards you mam

[@adharsh7703]

As I am a new person to cs side. Should I need to know in depth concepts of DBMS before start to work in SQL?

[@meRajdipKumarDora]

mam in 2nd example ,how can bc be the candidate key? As per my knowledge CK is the minimum of SK. so how can it be mam plz explain?😕

[@Uzair_Anwar2299]

in which lecture trivial and non trivial functional dependency discussed?? plz mention

[@chinchilimohit2600]

4th in the playlist

[@raghuvamsibhogi3170]

Trival functional dependency if same attribute present on both side otherwise it is non trivial functional defendence

[@devenv8407]

last one is not even in 2NF, D->A is partial dependency.

[@tembelninja3696]

A is a prime attribute

[@tembelninja3696]

A is a prime attribute

[@csboi5235]

notes : 3NF cant handle the cases when candidate keys overlap, so we resort to BCNF. eg fr BCNF : 9:56

[@anushajoshi5324]

in the last example when i was checking if R is in 2NF(since A->D and also E and even BC->E) or not I found that it is not then how can we say that it is in 2NF or any other higher normal form?