5 years and still no other playlist could match the quality of Varun Sir's teachings! Hats OFF!!
@imaanaftab
4 ай бұрын
But still some missing 😢
@sreeharims9015
2 жыл бұрын
Watched at midnight before exams and scored good marks in Dbms. Sir, you are a dronacharya.
@PraveenKumar-mi9jr
10 ай бұрын
me also, brother, this guy is awesome
@dhavallakhani5684
3 жыл бұрын
This guy is awesome, concept was cleared in first 3 minutes only But still he gave 2 examples for better understandings
@samisiddque8356
Жыл бұрын
g bilkul
@PraveenKumar-mi9jr
10 ай бұрын
chal jhoota, hawa bana rha hai,
@uguook
6 ай бұрын
bootlicker
@abhishekgm1102
4 жыл бұрын
Hi, 1 day before i really didn't know anything about DBMS, Today i wrote DBMS university exam quite well, I thought DBMS will become Back log, Thanks for your understanding tutorials. I watched all playlish of DBMS. A very big thumbs up for you!!!!!👍👍👍👍👍👍👍👍👍👍👍👍👍👍👌
@salmanbehen4384
4 жыл бұрын
Bhai aise nahi karte. Aise kar ke exam to clear kr loge lekin kuch seekh nahi paoge dost. Yaad rakhna bhai.
@fizakhan1427
2 жыл бұрын
I'm also applying just like yours strategy for studies since my 1st semester...and it's really workfull...only day befor exams, preparation of the whole sllybus by watching KZitem toturials.
@1amcaesar
Жыл бұрын
@@salmanbehen4384You cant speak for him, Exam se ek din pehle padhkr pass hona bhi ek skill h...Aksar toppers jo pure zindagi grind krte bethte sirf ek job ke liye - 90% laate aur last night vale 70%.. Statistically, They are doing much better and have a lot more time to build practical skills which will help them earn money
@rishikashyap7839
6 ай бұрын
2 hour before exam 😅
@mahamtahir2590
3 ай бұрын
How you covered all in one day before 🥲 Need tips
@Sujith0369
3 жыл бұрын
U got a good grip over Computer Science subject's.Watched all ur videos on computer architecture,Operating system and now DBMS thanks for all the stuff Really ur simply Awesome...
@pintusaini6838
4 жыл бұрын
If there was an option of 1000 likes, i would have given you. You rocked.
@GateSmashers
4 жыл бұрын
Thank you so much for your love and support.
@pintusaini6838
4 жыл бұрын
@Gate Smashers today i caught one mistake in the explanation at 6:12 . if prime attribute determines non-prime then it will not be in 3NF cause it fails to be in 2NF (prime att. is proper subset of CK). ref:Lec 29
@geethikaatthi9945
4 жыл бұрын
@@pintusaini6838 a non prime attribute can be determined by a prime attribute but it can't cause partial dependency hence in the above example roll no is the proper subset and there is no partial dependency so it is in 2NF
@dynamicsid8795
3 жыл бұрын
@@pintusaini6838 yes bruh u r right there is a mistake " if prime attribute which is also part of a candidate key either we can say proper subset of candidate key Determines non prime attribute then it will create partial dependency and due to partial dependency a normal form can't in 2 NF so not be in 3NF" but sir us saying it will be in 3NF
@rahuljoshi4599
2 жыл бұрын
@@dynamicsid8795 In the above example roll no. is not a proper subset of candidate key (it is a subset), therefore the above relation is in 2 NF.
@lalhotra_unofficial_5601
Ай бұрын
your explaination is too much understandable for all compatative exam like gate net set etc thank u
@arunsuryan9133
4 жыл бұрын
If a prime attribute can determine a nonprime attribute in 3NF that means that there exists a partial dependency (Becuase every prime attribute is always a proper subset of candidate key itself) and it violates 2NF. Please clear this.
@tonypepper
2 жыл бұрын
I didn't understand......
@pixelsbyme
2 жыл бұрын
yes i guess you are saying correct, it violates 2nf and therefore also 3nf
@ZainAli-wk9yd
2 жыл бұрын
For 3NF , one condition is that the relation should be in 2NF , if a relation is in 2NF then primary key of relation would be whole candidate key
@sumitkevlani5740
2 жыл бұрын
Left hand side should be candidate key or super key it means it violates the rule of proper subset case
@pranjalthakur1236
2 жыл бұрын
If Rhs is prime attributes , not LHS
@AmanKumar-fh6nu
Жыл бұрын
no words to describe your intelligence and way of representation! i got a back and wish i will clear it
@D_edits_258
11 ай бұрын
in which SEM..?
@abhinovize
3 жыл бұрын
Jo humare teachers poora semester padhkr samza nai pate, wo exam k ekdin pehel ye videos dhekkr samaj jata hai ;_; ...Big fan sir! kal wali exam pass hone ka poora credit ye bhai ko
@debasmitamukherjee5501
4 ай бұрын
tumahare waha teacher padate hai hamare yeha teacher just topic chuke chale jate hai
@Swami911
4 жыл бұрын
I m not a gate student but I love your way of teaching that’s y I watch your vedio and learn so much things great ...I wish Mai bhi aap jaisi teacher banu....lots of love❤️❤️❤️❤️❤️😍😍😍
@adeshmore22
Жыл бұрын
Hi what you're doing nowadays..?
@sajansekhu8785
5 жыл бұрын
thnkk u so much ji..the award of the great teacher goes to u...God bless u always ji...🙏🙏🙏
@RahulKumar-gl9rn
3 жыл бұрын
Neha..if you are watching this video then plzz return back my note copy..
@shristi8239
5 ай бұрын
Bhai waps Mila?🥹
@Itsyours64
4 ай бұрын
She couriers your note but there is a mistake in your address
@BruceWayne-wt7pu
4 ай бұрын
@@Itsyours64 Mere Ghar par aagayi bhai Tera address bol uspe bhejta hu
@kamranabbasi6757
4 ай бұрын
@@BruceWayne-wt7pu bro he doesn't need it anymore, he is pass out 😂😂😂
@___vishal9900
4 ай бұрын
Nahi bhai note nhi mile usse to back agayi hogi😢
@anoopjaiswal7823
3 жыл бұрын
Ek hi Dil hai Kitni bar Jeetenge SirJi❤️........🙏
@supriyanaik3100
3 жыл бұрын
Thank you so much for doing this great work ... you made this DBMS topic so interesting and easy to understand. This is helping me to clear my IT subject which I failed twice but now I am sure i going to clear it this time. Thanks
@mobeenali7338
Жыл бұрын
She failed again guys
@ManojManukonda
5 жыл бұрын
Thank you, sir I have watched DBMS videos one day before the exam and I had got clear that exam
@GateSmashers
5 жыл бұрын
wow great..bless you
@novicemakers_abhishekkamal
3 жыл бұрын
Their is more than 100 videos atleast 20 hr course and you watched all at once. Great 👍👍👍 how much data you get daily 😂
@novicemakers_abhishekkamal
3 жыл бұрын
First download the playlist and then keep watching👍
@shubhamkushwaha2716
8 ай бұрын
To be honest one of the bst channel what a explanation very clearly
@moksh7130
Ай бұрын
6 years down the road, these are still helpful af and always will be. No one else can teach concepts like this
@abhishek_kumarvelloreinsti1866
5 жыл бұрын
I am from vellore institute of Technology, studying CSE, 1st year, I have dbms paper tomorrow, watched all my relevant syllabus, now I am confident ☺
@asutoshghanto3419
3 жыл бұрын
first year me dbms???
@_iamankitt_
3 жыл бұрын
@@asutoshghanto3419 VIT Ka launda h Bhai vo AKTU ya IP Ka nhi 🤣
@634_abinashmishra3
4 жыл бұрын
Sir how come prime attribute presence in LHS of functional dependency meant that the relation will be in 3NF .If so then it will prove partial dependency and thus violating 2NF .I only understood the presence of candidate keys or super key obtained from candidate keys presence in LHS
@harrypotter-el4lx
3 жыл бұрын
prime attribute is in rhs
@vinayaksharma-ys3ip
2 жыл бұрын
@634_Abinash mishra Bro did you understand it now??
@VivekKumar-wl6lc
2 жыл бұрын
first of all it can't violate 2NF because it has passed the test of 2NF . After testing for 2NF it has come for 3NF.. Here condition of 3NF is only for that F. D which are already in 2Nf.
@adityakharde4265
12 күн бұрын
@@VivekKumar-wl6lc nah it violates 2nf if you take a np attribute being determined by a prime attribute
@rajasulal9264
5 жыл бұрын
ma na itni videoz dekhi lekin samaj srf in videoz s ahi u r so great tutor.... God bless u Ameen
@demon-iv3hv
Жыл бұрын
This vedio never gets old.. The explanation was lit🗿💥
@hrutujapawar2311
2 жыл бұрын
Just one word " Superb" teaching!!🙌🙌
@jagrutiyewale8891
Жыл бұрын
Seriously you are amazing teacher ✨✌️I cleared my all dought from your videos........ thanks 😊
@sanascookingspecial4055
3 жыл бұрын
Sir you are such a legend... your lectures are very helpful for my exams...I am preparing for my ajkpsc exam... inshallah I will get top scorers through your lectures inshallah
@sunnyjain630
5 жыл бұрын
This is the best video on normalization forms
@sarthaktripathy2294
4 жыл бұрын
You should explain why it is a problem if there is a non prime attribute determine a non prime attribute. Your explanation will be helpful for us. Thank you sir
@amrahmaryam8359
5 жыл бұрын
Sir your have great teaching skills.. please upload videos of all the topics of net syllabus.... Thank you so much for your sincere effort.
@techni8320
4 жыл бұрын
paji tusi great menu mere teacher toh jaeda tuhadi smjh aundi...really amazing explanation from u sir
@naveenkumarsahu930
3 жыл бұрын
Sir aapne bhut gazab padhaya h jo chote chote points aur trick bataiye h aapne bhut helpful h 🙏
@03_abhishekchoubey42
4 жыл бұрын
The way you explain sirjii love you from Indore ❤️
@_HARSHPRAKASH
Жыл бұрын
sir at 6:43 you said that prime attribute determing non-prime attribute is okay..... but that affects the 2NF condition as the non-prime attributess should be fully functionally dependent on the candidate key and not on its proper subsets. Please clarify!
@basavavenkatasaivaraprasad7228
Жыл бұрын
same doubt if c is prime and there is no problem then 2nf is violated right
@chandrimamaity920
3 ай бұрын
Tomorrow is my exam and now I am here to understand 3nf🙂🥹
@DeepakDubey-hx9cx
20 күн бұрын
Good 👹
@shivamsoni1547
2 жыл бұрын
how peacefully explained ☺️i got all my doubts cleared.
@shahilyadav4067
3 жыл бұрын
Only one word EPIC!!! The ease with which you teach is remarkable Sir!
@damiencooper5498
2 жыл бұрын
Thanks man my dbms teacher couldnt do it in the whole semester what you did in a few minutes
@beautyoftheindia8602
Жыл бұрын
In last question table is not in 2nf . So How it can be in 3nf ????plz answer me
@shafiqaliaki8953
Жыл бұрын
Best lecture easily understandable by me
@avneetsng
3 жыл бұрын
finally, I can feel both my ears
@scoc55vora15
Жыл бұрын
Amazing ❤️ Explanation with accurate example
@dheerajverma2909
2 жыл бұрын
Sir, you have great teaching skills Thank you so much, Sir
@MUHAMMADYASEEN-py1cm
8 ай бұрын
No one in world have a skill, how to teach computer science?your the beauty of sir Varun Singh.
@bankorium
2 жыл бұрын
I am IT officer aspirant and mera selection hoga ya ni pata ni but muje subject seekhne me maza aa ri hai becoz of Sir. Very Easy way apne sabkuch explain kr diya.
@panditsanjay7762
4 жыл бұрын
Sir mne phle aapse os pdha tha or fir mne DBMS search Kiya to m ye wish kar rahi thi ki aap ne bnai ho video or tab aapki video dekhi mne to m bhut khush hui ,☺️☺️
@priyanshugupta3816
Жыл бұрын
Bhaiya aapne 6:44 mein bola hai ki prime_attribute ---> non_prime_attribute. Aisa hone par toh wo 2NF rahega hi nahi because every NPA must be fully functional dependant on the candidate key.
@dumaloocanplay
Жыл бұрын
exactly my thought buddy
@harshtomar2694
Жыл бұрын
exactly
@avichiii
Жыл бұрын
that's what was thinking, D is proper subset of DB so, partial dependency is present.
@shivamtanwar2430
Жыл бұрын
@@avichiii D is proper subset of DB but A is a prime attribute... The condition is that LHS is a proper subset AND RHS is a non prime attribute...if any of these is false then there is no partial dependency
@ashwinnair1035
Жыл бұрын
bro condition dekho he have written or focus on or........lhs must be candidate key or rhs is a prime attribute dono me se koi ek ayega to satisfy kr jayegaaaa.....
@golang2351
4 жыл бұрын
you are awesome sir..great vision to describe the things easily.
@kunalsahay12
5 жыл бұрын
In the students table, a NPA(City) is being determined by another NPA(State). Isn't it the violation of first rule and you can conclude that it is not in a 3NF?
@adityakharde4265
12 күн бұрын
yeah i thought the same it violates 3nf it is only in 3nf if the attribute determined is always prime or the attribute determining must be a ck
@sarthakwagh1453
3 жыл бұрын
You are great sir 💯💯 Thank you so much for the clear cut explaination in easy language❤️
@abhishekroushan9735
4 жыл бұрын
you really, are doing a great job sir. hats off to you !!!
@rishavkumar2681
2 жыл бұрын
Thankyou sir to give best knowledge and clear the concept thanks alots sir....
@pratikshadake5470
3 жыл бұрын
🤩Such a excellent teaching skill you have!!!
@lokeshgodara1329
10 күн бұрын
in example 1 if c was an prime attribute then CK will also contain C.... so CK=ABC and then in c->D there would be a partial dependency and R(ABCD) would not be in 2NF hence 3NF also not valid
@madanmohan1660
3 жыл бұрын
At, 6:16, I think he is wrong. He said that the big flaw is that C is a non prime attribute, but in transitivity dependency that doesn't even matter. In 3NF, the condition is no non-prime attribute should be transitivity dependent on the primary key. And here D is dependent on AB.And C doesn't have anything to do with it . I may be wrong. If anyone find me wrong, pls explain!
@sanjanakulshrestha6374
4 жыл бұрын
Thank you so much for providing these videos. These are very helpful.
@Eknamram
2 жыл бұрын
You give ma notes plz 🙏🙏
@sabeenrao6563
5 жыл бұрын
your teaching method is very good sir....` FROM PAKISTAN
@ashishtayade047
14 күн бұрын
Thank you sir very nice gide & very nice best explain third normal form in dbms teaching video.👍
@bulkmotivation705
9 ай бұрын
EKDAM BADHIYA SIKHYA HAI 💖✨🔥MAZA AAGYA DHANYVAD BEST EXPLANATION ❤
@Pavicy0nmani2082
6 ай бұрын
Thank you so much sir. You save my time.
@mariarajooot3030
4 жыл бұрын
too good way of teaching..Allah bless u..and give u more and more you deserve...
@GateSmashers
4 жыл бұрын
Thank you for your love and wishes
@manshalkhatri9289
3 жыл бұрын
Thank you bro i got very good marks in dbms Subject i just watched till 1st to this 23rd lecture and your videos helped me too much to learn dbms concepts so fast : )
@rimshasarwar9592
4 жыл бұрын
you are the best teacher of the generation.
@pratyushbhardwaj9202
9 ай бұрын
00:05 Third Normal Form and Transitive Dependency 02:03 Roll number is determining the city using the transitive property. 04:03 Transitive dependency and candidate keys 06:07 The table is in Second Normal Form and the candidate key is ABD. 08:09 AB and DB are the candidate keys 10:13 A is helping, B is helping, and D is helping. 12:29 A table is in third normal form if it does not contain any transitive dependency. 14:29 To be in Third Normal Form, either the left hand side of each functional dependency should be a candidate key or super key, or the right hand side should be a prime attribute.
@newforpcclashroyal
8 ай бұрын
Crafted by merlin AI 🤓
@punitojha5560
3 жыл бұрын
Just a doubt : shouldn't it be Roll->City and City->State. because a single state may have multiple cities but one city will always lie in 1 fixed state
@chetansharma9369
2 жыл бұрын
Same doubt
@yogitachavan8992
3 жыл бұрын
thank you so much sir..this is very helpful for placement point of view also
@prajwal5778
9 ай бұрын
GREAT LECTURES SIR SIMPLE AND EASY TO UNDERSTAND KEEP IT UP 😍😍
@mayanksingh1007
8 ай бұрын
I have some confusion at 16:20 what if there is a Functional dependency ( D-->C) then will this table be in 3 NF because this dependency is Prime to non-Prime.. it is not transitive dependency( non prime - non prime) but is also not following the mentioned statement that LHS should be a CK / SK OR RHS should be a Prime attribute ... CAN ANYONE ANSWER THIS???
@aytida754
7 ай бұрын
if you change D -> C it, then D changes from a prim attribute to a nonprime attribute. hence D->C becomes a non prime Attr -> non prime Attr which is not allowed in 3NF. Thus it will not be 3NF
@AK-us1by
2 жыл бұрын
Explained a complex topic in a very easy format, Thanks.
@amrishticreative
3 жыл бұрын
Sir thankyou so much sir Sir aap bht acha teach krte Hain Apki videos mujhe bht achi smjh ati hai Agar sir aap telegram par notes de dete to better hota or bhi Aapne jo teach kiya uske hi notes bnate to jada better hota...... Ab notes kisi or ke bnane pdte h...... But thankyou so much sir Mujhe starting me DBMS itna hard lga tha fir maine KZitem par video dekhi or apki videos first time me hi smjh aa gyi...... Thanks a lot sir🙏🙏
@satyanarayanaguggilapu3735
3 жыл бұрын
Very good work you are doing and helping many GATE aspirants. Thank you sir. Wish this good work by you helps you further in your career.
@yougitarai2153
3 жыл бұрын
Sir your teaching skill is greatful .thank u sir to help me for study 😊
@Eknamram
2 жыл бұрын
Notes provid krva do 😓😓
@subhashishbehera7415
3 жыл бұрын
I will complete dbms in this 15 days that for sure , i am a cs student currently 2 year and dbms will be taught to us in 6 semester but i will complete it earlier 😄
@amaanraza1459
2 жыл бұрын
Sir I am from Pakistan and iam totally your fan you have an. Amazing style I am much impressed and understand lectures easily
@Mohsinlone13
Жыл бұрын
Brothee just update the second normal form theres some glitch in that vedio
@samiksha_gupta_1
Жыл бұрын
I don't know how to thank you enough Sir. I have watched a lot of videos on this topic over KZitem, tried my level best to understand from them but I couldn't. I am not demeaning them, they are great teachers but I was finding it very difficult to understand their explanation.I must say that the way you teach us is commendable.
@GateSmashers
Жыл бұрын
Thanks a lot
@kalyansharma1785
Жыл бұрын
aap ko bahot bahot dhyabadh , mujhe normal forms nahi samajh aaraha tha aap ke video ne clear kar diya , me nepal se hu aapko bahut sara dhyawadh
@TusharGodage-ci4od
5 ай бұрын
Teaching techniques is very unbelievable ❤😮🥰🔥
@085-atindey2
3 жыл бұрын
Best channel for gate preparation 😌
@mohdsalmanmateen553
5 жыл бұрын
One of the best Lecturer I have studied from ....you are awesome Varun sir
@nehairinirm7871
5 жыл бұрын
Sir... Thank you so much..Ur videos..Are very very... Useful..in exams....tq
@c.danielpremkumar8495
4 жыл бұрын
15:46 instead of checking LHS for CK/SK , would it not be enough to check ONLY RHS to be PA ? That is, If RHS is a PA, then the table is in 3NF. Therefore, why should we check LHS at all ?
@taramoni8129
5 жыл бұрын
sir! i am from bangladesh ..your teaching style is very beautiful..........
@sougatamajumder2078
3 жыл бұрын
#question: If a Prime attribute (But not CK or Sk ) defines a Non-prime attribute then what will happen?
@technologyguy2325
3 жыл бұрын
It will be partial dependency
@pushpamandi1120
9 ай бұрын
Since i found this channel i am fully afraid of how to pass dbms after listening to ur lecture i have full confidence on getting good marks as well as knowledge. Thank u sir☺️
@knowledgesumit8953
Жыл бұрын
You are a great sir 👍🏼💯💯
@muhammadhamzamaqsood8576
3 жыл бұрын
great brother! the whole playlist is gem. thanks for it
@azuboof
Жыл бұрын
if {roll no, state} is a candidate key, it can determine City. City can be defined by state alone and can be partially dependent on state right...so how is it in 2NF to be 3NF
@sagarikadutta6931
3 жыл бұрын
you are the best teacher.
@manpreetbatth2635
2 жыл бұрын
Your teaching method is too good sir
@Urooj21
5 жыл бұрын
Assalam o Alaikum ... I am your regular channel watcher.i am the student of msc(cs).sir please make more vedeos about normalization
@priyankvashist4103
4 жыл бұрын
You are great sir...... you have cleared all my minor doubts too
@prabalbhandari6029
4 жыл бұрын
great job by cameraman too
@shivanshusharma422
4 жыл бұрын
Sir u said at 6:45 a non-prime attribute can determine a prime attribute will be in 3nf but it won't be 2nf so it can't be in 3nf
@shivanidwivedi3276
4 жыл бұрын
U mixed two different things. Ya its correct that if a non prime attribute determines prime attribute then it will be in 3rd NF And dont forget if u proved that it is in 3rd Normal form,then it is already in 2nd NF.
@shivanshusharma422
4 жыл бұрын
@@shivanidwivedi3276 but what if look at this way that to prove something in 3nf we have to proof it in 2nf first?🤭
@shivanidwivedi3276
4 жыл бұрын
@@shivanshusharma422 we actually are not proving.If it is not in 2nd NF then we decompose it and make it in 2nd NF.
@shivanshusharma422
4 жыл бұрын
@@shivanidwivedi3276 it might be a solution yeah to decompose it and use it for 3nf.. right here 👍🏽
@gulshanara5581
Жыл бұрын
u r the BEST..Appreciate
@Mr.Streamer01
9 ай бұрын
whoi is watching this before 1 day of exam LIKE ------->
@unforgettablesences4607
2 ай бұрын
Bro 🤛🏼
@jaynandwana8878
2 жыл бұрын
Sir if non prime attribute is determined by prime attribute then it is not 2nf then it is also not 3nf. So p.a -> n.p.a is not 3nf as it is not in 2nf Means non prime attribute can only be determined by candidate key.
@Sandeep.Gupta27
3 жыл бұрын
Thank you so much for making these videos. Really helpful and easy to understand. :)
@mdimtiaz7706
Жыл бұрын
Neso Academy teaches like best teacher Gate Smashers teaches like best friend Love From Bangladesh🖤
@apurvmishra1674
3 жыл бұрын
You are an inspiration sir❤
@deepvyas4644
Жыл бұрын
what if rollno and state together is a candidate key and FD contains rollno --> city will it be in 3nf as is has do not have transitive dependency?
Пікірлер: 572