Lec-25: Third Normal Form in dbms with examples in Hindi | Normalization
Vložit
- čas přidán 2. 08. 2024
- 👉Subscribe to our new channel: / @varunainashots
0:00 - Introduction
4:16 - Example 1
6:54 - Example 2
► Database Management System(Complete Playlist):
• DBMS (Database Managem...
Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
• Design and Analysis of...
►Computer Architecture (Complete Playlist):
• Computer Organization ...
► Theory of Computation
• TOC(Theory of Computat...
►Artificial Intelligence:
• Artificial Intelligenc...
►Computer Networks (Complete Playlist):
• Computer Networks (Com...
►Operating System:
• Operating System (Comp...
►Structured Query Language (SQL):
• Structured Query Langu...
►Discrete Mathematics:
• Discrete Mathematics
►Compiler Design:
• Compiler Design (Compl...
►Number System:
• Number system
►Cloud Computing & BIG Data:
• Cloud Computing & BIG ...
►Software Engineering:
• Software Engineering
►Data Structure:
• Data Structure
►Graph Theory:
• Graph Theory
►Programming in C:
• C Programming
►Digital Logic:
• Digital Logic (Complet...
---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
► Subscribe to us on CZcams: / gatesmashers
►Subscribe to our new channel: / @varunainashots
► Like our page on Facebook: / gatesmashers
► Follow us on Instagram: / gate.smashers
► Follow us on Instagram: / varunainashots
► Follow us on Telegram: t.me/gatesmashersofficial
► Follow us on Threads: www.threads.net/@gate.smashers
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:
Email us at: gatesmashers2018@gmail.com
#3NF#ThirdNormalForm#DBMS
5 years and still no other playlist could match the quality of Varun Sir's teachings! Hats OFF!!
But still some missing 😢
Watched at midnight before exams and scored good marks in Dbms.
Sir, you are a dronacharya.
me also, brother, this guy is awesome
This guy is awesome, concept was cleared in first 3 minutes only
But still he gave 2 examples for better understandings
g bilkul
chal jhoota, hawa bana rha hai,
bootlicker
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...
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!!!!!👍👍👍👍👍👍👍👍👍👍👍👍👍👍👌
Bhai aise nahi karte. Aise kar ke exam to clear kr loge lekin kuch seekh nahi paoge dost. Yaad rakhna bhai.
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 CZcams toturials.
@@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
2 hour before exam 😅
How you covered all in one day before 🥲
Need tips
If there was an option of 1000 likes, i would have given you. You rocked.
Thank you so much for your love and support.
@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
@@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
@@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
@@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.
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
tumahare waha teacher padate hai hamare yeha teacher just topic chuke chale jate hai
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❤️❤️❤️❤️❤️😍😍😍
Hi what you're doing nowadays..?
Ek hi Dil hai Kitni bar Jeetenge SirJi❤️........🙏
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
She failed again guys
Sir your have great teaching skills.. please upload videos of all the topics of net syllabus.... Thank you so much for your sincere effort.
This is the best video on normalization forms
paji tusi great menu mere teacher toh jaeda tuhadi smjh aundi...really amazing explanation from u sir
no words to describe your intelligence and way of representation! i got a back and wish i will clear it
in which SEM..?
Seriously you are amazing teacher ✨✌️I cleared my all dought from your videos........ thanks 😊
you are awesome sir..great vision to describe the things easily.
whoi is watching this before 1 day of exam LIKE ------->
Bro 🤛🏼
ma na itni videoz dekhi lekin samaj srf in videoz s ahi u r so great tutor.... God bless u Ameen
thnkk u so much ji..the award of the great teacher goes to u...God bless u always ji...🙏🙏🙏
🤩Such a excellent teaching skill you have!!!
you really, are doing a great job sir. hats off to you !!!
Amazing ❤️ Explanation with accurate example
Only one word EPIC!!! The ease with which you teach is remarkable Sir!
Sir thanks for uploading good and helpful lecture series.
Pls upload lecture on 4nf and 5nf as soon as possible.
Just one word " Superb" teaching!!🙌🙌
Thank you, sir I have watched DBMS videos one day before the exam and I had got clear that exam
wow great..bless you
Their is more than 100 videos atleast 20 hr course and you watched all at once.
Great 👍👍👍 how much data you get daily 😂
First download the playlist and then keep watching👍
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
Explained a complex topic in a very easy format, Thanks.
The way you explain sirjii love you from Indore ❤️
Very good explanation of the the subject. Really loved it
Sir aapne bhut gazab padhaya h jo chote chote points aur trick bataiye h aapne bhut helpful h 🙏
To be honest one of the bst channel what a explanation very clearly
thank you so much sir..this is very helpful for placement point of view also
You are great sir...... you have cleared all my minor doubts too
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 ,☺️☺️
how peacefully explained ☺️i got all my doubts cleared.
you are the best teacher of the generation.
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
prime attribute is in rhs
@634_Abinash mishra Bro did you understand it now??
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.
Great way of the concept... 👌👍
Thanks man my dbms teacher couldnt do it in the whole semester what you did in a few minutes
EKDAM BADHIYA SIKHYA HAI 💖✨🔥MAZA AAGYA DHANYVAD BEST EXPLANATION ❤
Thank you so much for providing these videos. These are very helpful.
You give ma notes plz 🙏🙏
Outstanding Sir ! Subscribed ...
This vedio never gets old.. The explanation was lit🗿💥
Just wow 🔥
Sir... Thank you so much..Ur videos..Are very very... Useful..in exams....tq
great brother!
the whole playlist is gem.
thanks for it
your teaching method is very good sir....` FROM PAKISTAN
well done sir understandable lecture
GREAT LECTURES SIR SIMPLE AND EASY TO UNDERSTAND KEEP IT UP 😍😍
Assalam o Alaikum ... I am your regular channel watcher.i am the student of msc(cs).sir please make more vedeos about normalization
Best lecture easily understandable by me
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?
sir, u r too smart!
Very well explain all the normalized forms ,great efforts, thank you sir 🙏
🎉
Thankyou sir to give best knowledge and clear the concept thanks alots sir....
Sir, you have great teaching skills Thank you so much, Sir
Sir I am from Pakistan and iam totally your fan you have an. Amazing style I am much impressed and understand lectures easily
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.
sir! i am from bangladesh ..your teaching style is very beautiful..........
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 : )
Excellent explanation.
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 ☺
first year me dbms???
@@asutoshghanto3419 VIT Ka launda h Bhai vo AKTU ya IP Ka nhi 🤣
nice works sir stay happy
Excellent perfect 👌 i save my time
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
No one in world have a skill, how to teach computer science?your the beauty of sir Varun Singh.
great job by cameraman too
bohat awla bro.Keep it up
Best channel for gate preparation 😌
Sir your teaching skill is greatful .thank u sir to help me for study 😊
Notes provid krva do 😓😓
Nice explanation sir...
Gud command on these topic
You are great sir 💯💯
Thank you so much for the clear cut explaination in easy language❤️
u r the BEST..Appreciate
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.
💎 Crystal clear 🔥
outstanding teaching 😃😃
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 😄
Op Explanation Sir ❤️❤️❤️❤️❤️❤️
thanks sir for these wonderful videos.
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 CZcams par video dekhi or apki videos first time me hi smjh aa gyi......
Thanks a lot sir🙏🙏
Thanku.. thanku ....thanku... soooooooo much sir supppp 🥰🥰
thnku sir...aa gya smaj
Better than knowledge gate 💯
you are the best teacher.
Your teaching method is too good sir
Thanks brother 🙏🙏🙏🙏
amazing sir
You are a great sir 👍🏼💯💯
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
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☺️
Nice explained sir 😊
One of the best Lecturer I have studied from ....you are awesome Varun sir
Thank you so much sir. You save my time.
Well done 👍 sir
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.
I didn't understand......
yes i guess you are saying correct, it violates 2nf and therefore also 3nf
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
Left hand side should be candidate key or super key it means it violates the rule of proper subset case
If Rhs is prime attributes , not LHS
Thank you so much for making these videos. Really helpful and easy to understand. :)
you are doing good
U are so good sirji great......