4.13 How to Identify Normal Form Practice Question Part-1

[@KNOWLEDGEGATE_kg]

For complete DBMS, check out this video: kzbin.info/www/bejne/j4PRm3qbhsemfrM

[@ScreenieMyMusic]

Bro, im not even indian, but my parents used to watch bollywood films, and i learnt hindi through that. And its paying off, this guys amazing. He really wants you to understand, this is how you teach! Thank you for the videos!!!!!!!

[@sajalagrawal1430]

yes , we INdian always try to make things easier to learn .it is in our gene

[@ArkabrataDattaRoyChowdhury11]

Thanks for the nice comment man. It's really rare for foreigners to appreciate Indian online teachers. They work really hard and in my opinion are the best in what they teach.

[@deadlydangaming]

I can agree , I'm from Pakistan and i respect India and their teachers so much , they are really good and they know how to properly teach and making things alot easier for us , Respect from Pakistan 🇵🇰

[@yutaitadori7318]

@@deadlydangaming only KZbin tutors dude !!!

[@hrithik5220]

Sachit sir ki international fan following hai

[@codingwithelhacen990]

Taking my hat off to Indians for their WELL simplified explanations EVERYWHERE. Thank you

[@KNOWLEDGEGATE_kg]

Thanks a lot for your kind words ❤ Keep learning & supporting! Stay connected for more amazing videos & contents 👍

[@ash_engineering]

please upload MVD , 4NF and 5NF videos also .. your explanation are really very easy to comprehend, and I really dont understand these topics at all. I am preparing for GATE 2017

[@nausifmaknojia8713]

plz can u upload 4NF

[@vivekojha4807]

Gate nikla?

[@yutaitadori7318]

Why are you preparing for gate

[@vidhikumar1664]

@@vivekojha4807 lol, now its your time!

[@vivekojha4807]

@@vidhikumar1664 ⊙﹏⊙

[@KNOWLEDGEGATE_kg]

🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg 🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg

[@surekhapadmam2336]

I can't believe myself solving all examples which I've feared only by looking at them. ☺️ It's hard not to comment. Thank you sir ❤️

[@KNOWLEDGEGATE_kg]

Well done !! Great, Visit www.knowledgegate.in for more courses and content !!

[@TheBergsteinsson]

Watching from Iceland. You have really helped me alot! Thanks mate :)

[@akshaypathange3582]

Really? Wow!

[@AdishKGupta]

why do you need to watch this? Do ice skating and enjoy...

[@mitrajsinhchavda5659]

@@AdishKGupta that's where trust issues begin Iceland has greenery and greenaland is covered by ice Lolzz

[@being1better801]

@@mitrajsinhchavda5659 that is where trust issues begin You would have told him ,why can't he watch but no😂, you explained him about ice and greenary.

[@mitrajsinhchavda5659]

@@being1better801 welcome to India

[@shekharpandey844]

great examples, one thing to add , as soon as we get Partial dependency we can immediately say it is not in 2 NF , and conclude

[@sharkk2979]

Your technique of finding 3nf is very good You recognized the thing You r hacker

[@KNOWLEDGEGATE_kg]

Hello Sharang, thanks for appreciation. :)

[@adityapaithon6499]

In 3rd case how did you find candidate key?

[@saumyojitdas4212]

@@KNOWLEDGEGATE_kg In the first question u haven't checked the other dependencies ,u check the first two and concluded that the table is in 1nf. But earlier at the starting of the video u told to check for every dependency. Is it a shortcut?

[@saumyojitdas4212]

In the first question u haven't checked the other dependencies ,u check the first two and concluded that the table is in 1nf. But earlier at the starting of the video u told to check for every dependency. Is it a shortcut?

[@salmananjum-thestoryteller1515]

I'm from Electronics background, I haven't studied these courses in my graduation so guys tell me are these topics that simple to understand? or is this the wonder of this man's skills that I'm able to solve each and every question by myself in the 1st go? For you Sir, in our Pakistani Slang --> Chaa gaye ho aap ;-)

[@rajeshrathod6344]

Topic is difficult but its easy only due to best teaching.

[@silverzero9524]

i would say these topics can be a little tricky to get and also students arent usually very interested in these because they seem boring

[@vishaldhanani7241]

Sir aap jese or bahut sare teacher ki zroor hey....hmare clg me Jo teacher ushe bhi apke video dekh ke sikhna chahiye..

[@papanchowdhury7881]

sir ur style of solving NF is so good.. I love it so much.. But I have a request.. plz plzz upload for finding 4nf 5nf dknf mvd plzzz.. preparing for gate 18..

[@devarshisingh9349]

Wow! I missed my coaching classes on this topic. I am glad I missed. Thank-you.

[@kanhaiyaya]

Your lecture video is filled with your passion to make the student understands the basic concept first and your way of interaction is just like real time viewing that makes us fully involved during the session , and of course without getting bored. I really appreciate your work. Thanks for your amazing teaching methodology.

[@vimmysaini]

amazing amazing. ..... pehli bar normalisation smj ayi hai. .life me.. great work sir.... best lecture.. Thank you so much....

[@KNOWLEDGEGATE_kg]

Thanks for your appreciation,glad i could help :).

[@Angela-Gee]

you are a GEM... I understood these concepts finally

[@KNOWLEDGEGATE_kg]

Thanks a lot dear student, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@devanshmesson2777]

Thank you so much for a crystal clear explanation! It helped me so much in clearing the concepts!

[@KNOWLEDGEGATE_kg]

You're most welcome dear, keep learning & supporting ! Do visit our website www.knowledgegate.in for more amazing courses & contents !

[@relaxandchill4968]

Sanchit sir you are my inspiration you are the best teacher from you any student will be wiling to learn I just love your vedios crisp explanation thank you sir you are the best🤩🙏🙏

[@KNOWLEDGEGATE_kg]

Thanks a lot dear for your kind & generous words 😍😍 Wish you all the very best for your future, stay blessed 👍😊 Keep learning & supporting, do visit our website www.knowledgegate.in for more amazing contents & courses 👍

[@bestlearning2644]

Very good teaching sir..you teach very well..because i dont understand the concept of normalization but after watching your videos, I can solve all the questions of normal form. Thank you sir

[@sagrikachauhan519]

we need teachers like you in our colleges.The university system of our country sucks

[@jssaini1998]

Thanks sir.. your video is the best source for learning all the normal forms in a single go! the only perfect solution for dbms on inernet!

[@darinebouzar3575]

After watching this video I do not have any problem with BCNF, that was like a big ghost for me, God bless you sir

[@rohan8758]

I have done this all question myself in less time due to your teaching style. Thank you sir....

[@Jyoti_Trivedi]

Thank you so much sir....I am doing this like homework in my notebook with interest..... Thanks again to spread knowledge free....u r great 😇👍

[@gurinderkaur6377]

I think it better to chk for 2nf first...then 3nf n then bcnf... First check if there any fd which is partial dependency..nd no need to check further.. nd if there is no partial dependency...then chk for transitive...( If u find even a single dependency which is transivite ( using ur logic) ..then no need to check further....) Just a suggestion to save time

[@priyapatel796]

Sir u r awesome ur teaching style is Awsmmm... U Teaches all easy way to solve the pblm.and help me in all sem Exams at last moment... Thankuuuu so mch ......

[@gauritiwari2373]

Awesome...fear of normalisation hv gone..thanks..you gave simplest way to check out normalisation forms..❤

[@meesamali8782]

Sir I was struggling for few days to understand normalization topic but you made it really very simple. Thanks a lot. can you please tell me the other subjects you teach or upload videos ?

[@bppb829]

after watching all lecture one of normalizatin i hv bcm yr spuper fan .....thank u so much sir

[@pankajhindlekar7045]

Its Amazing Collection of SQL Concepts..really Helpful for me..kep it up sir..You are doing really good job...👍

[@rajrehman9812]

good evening sir, sir thank you for such a beautiful explanation of normal form solutions,but sir in this video of part 13 I was unable to identify why u have chosen ABC,ACD as super key? I will be grateful to u sir for the explanation..thank you sir

[@mohsinkirmani1833]

Hi sir, This is one of the best channel I came across over KZbin for educational concerns. Very well explained, up to the point. Kindly upload some videos of 1NF, 2NF and 3NF pertaining to table decomposition. I'll be very thankful to you. Stay happy and keep this good job up :)

[@anjumshaikh6060]

pls uplode video to solve the question : consider R=(A,B,C,G,H,I) and the set F of functional dependancies ,F={A->B,A->C,CG->H,CG->I,B->H}. The correct member of closure of F are :(a) A->H,CG->HI,AG->I (b) A->HI,CG->A (c) AG->BI (d) A->B,B->I

[@sushmita7184]

(a)

[@shekharkumar8780]

Thanks, sir.. your video is the best source for learning all the normal forms in a single go! the only perfect solution for DBMS on the internet!

[@adityadevchakke3668]

A great salute..!!! Hats off to you sir...an amazing human being with gifted talent of teaching ,making efforts to give this knowledge.THANK YOU SIR FOR ALL THESE VIDEOS

[@seanjalali9788]

Hi Knowledge Gate, Hi Sanchit. First of all, thank You so much for These Videos. I am new to this Community and I am very glad to learn from You. My Question to You and the Community is: Can we say for Example 1, that the second Dependency is not in third Normalform because A is not A Candidate Key ? I guess DE as Non-Prime Attributes have to rely on a CK and not a part of Prime-Attributes (as here in A). Right ?

[@anshgyl]

Yes absolutely right the dependency "A --> DE" is a partial dependency as "A" is a part of the candidate key and not the whole candidate key. Therefore it is not in 2NF, hence it can't be in 3NF.

[@catarina-6614]

Thank you for your videos!! I have a question tho, how would you normalize: R(A,B,C,D,E,F) with Functional Dependencies = {ABC -> DEF, D-> E, ABC -> A} and in what form is it? Thank you once again!

[@sushmita7184]

2NF.

[@ashishwildlifeandtravelpho7308]

Ur knowledge is so refined really thanks for such nice lectures keep up ur good work sir :)

[@murarisinghchoudhary5377]

The Lectures are very useful for those who does not have basic concepts

[@uvdg8t]

supersirji aaj pheli bar engg ke 10 sal bad normalization sahi se samj aaya

[@shradhasoni3177]

Simply just one word. Excellent.

[@KNOWLEDGEGATE_kg]

Thank you so much dear Shraddha😀 Keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@kalyanchoudhury6254]

ur explanations are really good and understanding...I like ur all videos so much like(like os and all).. But I have a request sir ,plzz plzz upload 4nf 5nf dknf and mvd also,,,preparing for gate 18 as well as semester.....love u sirrrrrr...

[@shagunverma8597]

sir, can you please check this relation for bcnf?? R is (A, B, C, D) with FD’s A -> B, B -> C, C -> D, D -> A.

[@subhamkumardash3515]

Sir the way you explain each and every concept (whether the topic is easy or difficult) is fantabulous. Every video in this series is extraordinary. Keep it up.

[@surbhisharma-qp1gl]

Hello sr I must say u explain in very well manner and now my concepts are more clear .thanks a lot

[@KNOWLEDGEGATE_kg]

Thank you for watching and providing feedback.. Will try to make more easier ones..

[@surbhisharma-qp1gl]

KNOWLEDGE GATE Can u plzz upload the videos In dependency preserving

[@muj99ali]

"Here we see partial dependency. Hence it also not in *WHAT* ? 2NF." That "WHAT" is repeated so many times during explanations 😂 Btw Great tutorial videos sir ! Every category of student can find your tutorials helpful. Thanks for putting in the effort.

[@saumyojitdas4212]

In the first question u haven't checked the other dependencies ,u check the first two and concluded that the table is in 1nf. But earlier at the starting of the video u told to check for every dependency. Is it a shortcut?

[@Krodhaislive]

@@saumyojitdas4212 no need to check further. that's the logic

[@himanshulahare7378]

Lol

[@arungarg5790]

hello sir how to solve this question.. A-->BCD BC-->DE B-->D D-->A Compute a canonical cover for the above set of functional dependencies F; give each step of your derivation with an explanation. Give a 3NF decomposition of r based on the canonical cover. Give BCNF decomposition of original functional dependencies. can you get bcnf deconposition using canonical cover.

[@adityasinghaswal4923]

Your way of teaching is very lucid.Subbed and eagerly waiting for more videos.

[@rajeshkotina]

superb explanation sir..but bit confused with logic of 3nf here while telling in examples..3nf video part was clear..but wen u apply in examples it's a confusion..

[@amandeepsingh-ci4gb]

thanks a lot......video concepts are good enough to grasp the knowledge....no time wastage,,,i recommend it for others

[@namanmittal9726]

Your videos are really helpful ! Thankyou so much sir.

[@krishnaupadhyay4736]

Sir can you please upload a video on joins! As the way you are explaining is very good and normalisation questions in gate are mostly appeared with the joins

[@abcabc-bu9rk]

college teachers: bacche normalization jaldi se samaj gaye meanwhile students: isko neta bana do learning from knowledge gate Thanks sirr🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏

[@ajayraj4911]

sir aap to humare senior ho , DTU awsm lecture's

[@chinmayagrawal5119]

Really One of the best!!!! Thanks sir for uploading such fantastic videos

[@learnfreewithvaibhaviupret5489]

My all doubts are clr after watching this video, thankyou sir 🙏

[@KNOWLEDGEGATE_kg]

Most welcome ❤ keep learning & supporting! You can also check out our course for all Computer Science subjects, sharing the link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science

[@nezmika2911]

Nice video sir ! Thank u so much, very clear, keep going! U r really awesone ..Thank u knowledge gate!

[@pavankulkarni9756]

sir please make videos on 4NF and 5NF and please solve problem on how to normalize a relation videos on these concepts will help me a lot in my university exam Thanks a lot sir for uploading such a wonderful set of videos .

[@SHASHANKRUSTAGII]

Love you sir. Thanks for this video. This would be my third GATE attempt with job. I hope I ace this exam #171 days left

[@hemajeya3532]

Really outstanding teaching. Super sir.

[@learnwithmanu5655]

very clear cut and Excellent explaination sir g thank u very much , sir g please upload the video on multivalued dependency , join dependancy , 4NF , 5NF, Relational calculas ,relational algebra. please sir g if u have time .

[@AhmadRadwanalarfdah]

You're really good tbh. Sad that professors don't teach in this way.

[@manantyagi614]

thank you so much sir, my exams are approaching. And you have explained so well....#saviour

[@KNOWLEDGEGATE_kg]

You're most welcome dear Manan, keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@sounaksana8128]

I am really very grateful to you sir.Your tutorial lectures tremendously help me to do very well in the sem.Thank u very much sir...

[@sketchesbyMg]

Well done sir !!!You are a brilliant teacher..

[@sustadasgupta2780]

Candidate key is a minimal form of super key as sir has explained. So, at first we are finding out the minimal version of super key , i.e. candidate key, or any super key? Also, the Prime attribute that we need to check for 3NF...is the Prime attribute a part of a super key or necessarily a part of a Candidate key?

[@AMITSINGH-nq4sy]

Sir In example no.5 wrong candidate key is being defined in the video at time 22.04

[@patelurvesh9404]

Sir you have done a great job. I am enjoying your teaching.thank you so much. Sir one request to you that please upload whole course of DBMS. I hope you will think on request. And thanks again.

[@darshanpatel_1611]

Maja aa gaya bhai Pura Chapter Clear ho gaya 😅❤

[@KNOWLEDGEGATE_kg]

Glad to know this❤ Keep learning & supporting! Stay connected for more amazing videos & contents 👍 You can also check out our CS bundle course for complete preparation of Computer Science subjects, sharing course link below: www.knowledgegate.in/learn/Zero-to-Hero-in-Computer-Science

[@VivekSharma-yl9ki]

In the eighth example, ABD-->E, You take it as a fully dependency but how it can possible because AB is the subset of ABD and D is the part of ACD.

[@shwetashirsat383]

Thank you so much sir..It is very much helpful for my NET exam.... God bless you abundantly...

[@madhavmohan5754]

Sir, in the 3rd example I am feeling doubt as you are saying "DC" are a non-prime attributes but "BDC" is a candidate key in itself at you said 17:04 "DC" is not a part of candidate key!, sir please help

[@59ks68]

Thx sir,i watch your video before my exam,its cover my whole semester lesson.

[@PakistaniMaterial]

*Sir, Your lectures are great

[@shekharkumar8780]

yes

[@InformaticaVids]

Given R(ABCD) and AB → C ; ABD → C ; ABC → D ; AC → D which the highest possible normal form for the above relation ?

[@dheervaryani5873]

Arup Dey 3nf is the answer?

[@warunparker4061]

AB is the candidate key and now if we check 1) It's not in BCNF because AC is not a super key 2) it's not in 3NF because first three fd no problem but last one AC here it's not a candidate key or a super key. So check RHS is that a prime attribute? (part of candidate key!?) Nooo D isn't. Therefore it's not in 3NF 3) and also AC->D D depends on A. Therfore Partial dependency therefore not even in 2NF Answer 1NF

[@asitbiswas1242]

@@warunparker4061 till the 2nd point that is all right. But in the 3 rd one As AB is the candidate key so in case of 2 NF in left hand side there must be a proper subset of candidate key. As AC is not a proper sub set of AB thats why it will be of 2 NF. So the highest possible Normal Form will be 2 NF.

[@asitbiswas1242]

2 NF

[@bhumikasharma2281]

Sir add more videos related to DBMS. Keep doing the nice work!!!

[@asmaramushtaq8479]

I need 2 learn 4th NF & 5th NF ...give tutorials on them

[@brijeshsharma7273]

Salute to your explaining skills.. It helped me a lot...

[@Alina-er9vv]

In the bottom-up approach, since, we have checked for BCNF before, and we found out that alpha is not a key, we then went on to check 3NF, so instead of checking if alpha is a key (which we already figured that it's not), we can directly prove beta to be a prime attribute, right? That would save time.

[@shantanu0707]

I'm so thankful for these amazing videos. Please make videos on 4NF, 5NF, Multivalued dependency and DKNF

[@vikash-mw9kt]

Its really a great video sir.....truly a great explanation.....keep it up

[@arpitamaiti5623]

vikash choudhary caCapCAT

[@WimpyWarlord]

This is pure gold!

[@shivamsaxena13]

sir, i watched all your dbms videos from part 01 to part 16. your each and every video is quite simple and easy to understand. but in this video i have a small confusion in 3nf explanation. sir, is video se pehle ki jitni bhi videos hai usme aapne ye bataya hai ki koi table 3nf mein tab hi hogi jab wo 2nf ki sari condition ko satisfy kar rahi hogi aur usme transitive dependency (when a non prime attribute depend upon another non prime attribute) nahi hogi aur agar transitive dependency hogi to wo table 3nf mein nahi hogi. lekin sir is video mein jab aap first question ke A->DE mein 3nf check kr rhe hai tab A->DE mein transitive dependency to hai hi nahi kyunki DE bhale hi non prime attribute hai par A to prime attribute hai jiska matlab hua DE (non prime attribute) depend upon A (prime attribute). to sir mera question ye hai ki A->DE ko kis wajah se 3nf mein nahi rakha gaya hai ?

[@anshgyl]

A --> DE ko 3NF me isliye nahi rakha qki woh toh 2NF me bhi nahi hai. 2NF ki condition hoti hai ki har NON-PRIME complete candidate key pe depend kare uske kisi part pe nahi, par yahan pe "DE" sirf "A" pe dependent hai, jabki 2NF me hone ke liye usse complete candidate key "AB" par dependent hona chahiye tha. Isliye hum isko 3NF me nahi rakh sakte.

[@PravinJanjal92]

thanks! this is the only video on net for soluttion

[@KNOWLEDGEGATE_kg]

Thanks for appreciation.

[@chinmayrath8494]

Amazing video series. I absolutely love it!

[@sandeepshyoran5906]

thank you very much sir for such a simple and easy explanation for such type of complex topic

[@ravikumarprajapati3950]

teaching technique is marvellous

[@hashiratanjirou]

I really enjoyed so much to watch this video.Welldone sir.Keep it up🙏👍👌🏻

[@vinayaksharma-ys3ip]

Great Lecture Sir!!!

[@KNOWLEDGEGATE_kg]

Thank you so much dear Vinayak :) keep learning & supporting !! Do visit our website www.knowledgegate.in for more courses & contents !!

[@shashanksharma4377]

Wahh...Kya baat hai (3 Idiots movie dialogue fits perfectly here) 😀

[@shortsongs2]

the way you teaching is awesome....!

[@manojrao327]

u r great sir

[@ashutoshomer5269]

Thank you very much sir .... Well explained

[@sandeepKumar-hc1co]

thank u very much sir,very good explaination.

[@utkarshagrawal839]

you are doing a great job sir

[@Mahaveerkeyluck]

Thanks for making these video,and big thanks for making these video free.

[@food__o__graphy]

Your teaching style is TOO GOOD!

[@suvadipghosh1385]

i am privileged to get you sir...it made me a master

[@AmitVerma-gi8bg]

A lot of thanks sir you are grate and your teaching style is awesome.

[@jeeteshgupta7634]

Sir Please upload whole series on IDBMS.. We have to prepare for End Sem .. Please !!!!