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 👍

[@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 !!

[@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

[@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

[@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 ⊙﹏⊙

[@vishaldhanani7241]

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

[@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?

[@KNOWLEDGEGATE_kg]

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

[@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 :).

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

[@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

[@devarshisingh9349]

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

[@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 👍

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

[@rohan8758]

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

[@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

[@murarisinghchoudhary5377]

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

[@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 😇👍

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

[@bpgis829]

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

[@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

[@gauritiwari2373]

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

[@sagrikachauhan519]

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

[@namanmittal9726]

Your videos are really helpful ! Thankyou so much sir.

[@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

[@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 !!

[@amandeepsingh-ci4gb]

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

[@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 ?

[@chinmayagrawal5119]

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

[@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

[@uvdg8t]

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

[@hemajeya3532]

Really outstanding teaching. Super sir.

[@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)

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

[@ashishwildlifeandtravelpho7308]

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

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

[@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

[@shwetashirsat383]

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

[@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

[@pankajhindlekar7045]

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

[@59ks68]

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

[@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

[@ajayraj4911]

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

[@vikash-mw9kt]

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

[@arpitamaiti5623]

vikash choudhary caCapCAT

[@brijeshsharma7273]

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

[@adityasinghaswal4923]

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

[@Mahaveerkeyluck]

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

[@PravinJanjal92]

thanks! this is the only video on net for soluttion

[@KNOWLEDGEGATE_kg]

Thanks for appreciation.

[@abcabc-bu9rk]

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

[@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

[@sandeepshyoran5906]

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

[@AmitVerma-gi8bg]

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

[@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 !!

[@AhmadRadwanalarfdah]

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

[@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 :)

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

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

[@suvadipghosh1385]

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

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

[@shreekrishnaagrawal439]

The best ever video and tutor found on youtube...thankx 4 the vdio

[@nezmika2911]

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

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

[@tahirmehmood8837]

Thanku sir your method of teaching is so good....

[@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

[@tanuj05]

You're amazing, Sir! You've helped me a lot..thank you soooooo much!

[@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?

[@hashiratanjirou]

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

[@sandeepKumar-hc1co]

thank u very much sir,very good explaination.

[@chinmayrath8494]

Amazing video series. I absolutely love it!

[@fahadpervez94]

Thanks! a lot sir keep it up you explained it very clearly

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

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

[@asmaramushtaq8479]

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

[@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

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

[@ashutoshomer5269]

Thank you very much sir .... Well explained

[@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

[@shortsongs2]

the way you teaching is awesome....!

[@bhumikasharma2281]

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

[@ankitgarg2006]

very nice and intuitive videos. Thanks a lot sir

[@Uplift.U0]

u make me understand very well....thanku so much sir.........

[@ravikumarprajapati3950]

teaching technique is marvellous

[@kishoresrinivas6322]

Wow, Nice video . You saved me from exam!

[@AMOLPALAV44]

great sirji, once again you came to the rescue, tysm

[@arpanajain2787]

You have good command on every topic of computer science please also upload er model in dbms

[@food__o__graphy]

Your teaching style is TOO GOOD!

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

[@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

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

[@DanielAngali]

Sir ,Thanks alot for your wonderful crystal clear explanation.I request you upload videos on 4NF and 5NF.

[@shantanu0707]

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

[@jagmohanagrawal7636]

Great explanation sir....Please continue with the good work

[@minakshee4672]

Thank you sir. watching whole video was worthy

[@AMITSINGH-nq4sy]

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