normalization in dbms | normal forms | 1nf, 2nf, 3nf, bcnf, 4nf, 5nf normal forms with examples

Рет қаралды 300,561

Күн бұрын

Complete DATABASE MANAGEMENT SYSTEMS ( DBMS ) SUBJECT PLAYLIST:
• database, characterist...
MY INSTAGRAM ID :
nagendrasai_che...
PYTHON PORGRAMMING COMPLETE SUBJECT PLAYLIST:
• introduction to python...
PYTHON STUDY MATERIAL:
drive.google.com/file/d/1_hr4...
complete pps ( c language ) subject playlist is given below:
• Video
Complete DATA MINING SUBJECT Tutorials IS AVAILABLE IN BELOW PLAYLIST :
• classification and pre...
Complete DESIGN AND ANALYSIS OF ALGORITHMS(DAA)SUBJECT LECTURES IS AVAILABLE IN BELOW PLAYLIST :
• Design and Analysis Of...
complete web technologies tutorials is available in below link:
• introduction, overview...
Complete INFORMATION SECURITY playlist :
/ @nslectures
COMPLETE COMPILER DESIGN PLAYLIST:
• compiler design
COMPLETE DATA STRUCTURES AND ADVANCED ALGORITHMS LECTURES :
• flow networks, ford fu...
WEB AND DATABASE SECURITY FULL LECTURES:
• WEB AND DATABASE SECURITY
CYBER SECURITY FULL LECTURES:
• WHAT ARE CYBER CRIMES ...
Complete WEB TECHNOLOGIES lecture is present in below playlist :
• Playlist
PLEASE SUBSCRIBE TO MY CHANNEL
NS LECTURES channel is online subject learning platform for engineering CSE/IT students.
For Study Materials please visit:
lecturenotes.in/u/nagendrasai...
#DBMS#Databasemanagementsystem#btechDBMS#Databasemanagementsystems#DBMSforbtech#Databasemanagementsystemforbtech#DBMSforbtech#Databasemanagementsystemsforbtech#btech#cse#aiml#datascience#cse#UNIT1#completeunit1#r18#r20#r22#jntuh#jntuk#jntua#database#databasemanagementsystem#normalization#normalforms#firstnormalform#secondnormalform#thirdnormalform#boycecoddnormalform#fourthnormalform#fifthnormalform#firstnormalformexample#secondnormalformexample#thirdnormalformexample#boycecoddnormalformexample#fourthnormalformexample#fifthnormalformexample#dbms#unit3#1nf#2nf#3nf#bcnf#4nf#5nf#1nfexample#2nfexample#3nfexample#bcnfexample#4nfexample#5nfexample

Пікірлер: 183

@PonnadaHariSaiKrishna-rf1zs 7 ай бұрын

Bro u r saviour for many students 😭😭

@VishnuVardhan-yz6jh 7 ай бұрын

Yes bro

@Indian-ty8iz 5 ай бұрын

1 day before sem

@anirudhyellamraju8296 5 ай бұрын

same broo

@shubhamgameryt6687 2 ай бұрын

5 hours after exam 😂

@jackob3073 Ай бұрын

8 hrs before exam

@chanquanpham3216 3 ай бұрын

Straight to the point, unlike my teacher. Very straight-forward and easy to understand

@edu-social-cbse157 9 ай бұрын

Best video on normalization until now..easily understood perfectly thank you sir 🙏

@muhammadjunaidkhan255 6 ай бұрын

Sir i watched so many videos related to normalization but none of them worked for me.....sir you explained each and every single point in supreme easy and clean way....thank you so much ......lots of love from PAKISTAN...You are legend sir.❤❤❤❤❤.

@shankarshiva5587 9 күн бұрын

Simply brilliant. 🎉🎉.. Magnificent!! Even high paid professional can't explain in lay man undeserving way...

@GouseMastanShaik 9 ай бұрын

Perfect explanation. The objective should be to make students understand the main concept. this is the perfect example for explaining the concepts

@syam_vlogs.9493 2 ай бұрын

I saw this vedio before my exam.... thankyou so much...for making this vedio

@bablufunnyvideos8945 3 ай бұрын

Surely for tomorrow exam,I will get 10 marks..nice explanation bro

@mastanmannepalli7823 3 ай бұрын

Super gaa chepyav bro maa clg lo kuda Ela cheppi unte nenu clg first 🥇 vachevadini bro

@user-gm1iu8vo6s 7 ай бұрын

last day before exam and it really helped me learn....I was so confused in this topic before. Thank you so much anna. Please continue making videos like this

@it.b.11.pratikmore4 Ай бұрын

You explained everything so well! Each word was clear and understandable. I watched 3 or 4 videos before this and still didn't get it, but now it's all clear.

@harikrishna21389 Ай бұрын

Excellent explanation bro every single word is explained clearly before this I have watched 3to4 videos i didn't understood. but now it is clear

@kitkatgaming4852 2 ай бұрын

There can't be a simpler explanation than this❤

@user-gn6cv9nk3t Ай бұрын

But what for the records of language he said we are not considering that table in 2nf that's totally in appropriate

@Happy_509s......... 11 күн бұрын

Just saw this before my mid exams easy straight to the point and information is clear and accurate thank you so much

@karanthakur4306 2 ай бұрын

Best tutorial till now on normalization..!!!Thank you so much

@user-mg6th2et2d 3 ай бұрын

Very useful, sir... I was so confused about this topic before, but after watching this video, I'm very clear on this topic. Thank you, sir 🤝🤝

@Geethabhagyasri Ай бұрын

Super video , having clear cut explanation...thanks a lot bro , tomorrow is my SEM exam

@hadassahvadranam6212 6 ай бұрын

Thank you sir... Mostly Examples helped me to understand the concept.

@dhanyarineesh8699 9 ай бұрын

Very useful sir... Cleared ur lessons easily 🙏

@vkyadavavky326 5 ай бұрын

Day after tomorrow is my dbms semster exam and this is the main question, you’ve cleared all the doubts of this question. Thank you sir , keep going. ❤😭

@whoami3424 12 күн бұрын

last day before exam and it really helped me learn....I was so confused in this topic before ,Thank you so much anna, Please continue making videos like this..............

@shivamexplainer1122 10 ай бұрын

Sir to be honestly... One of the best ever video for Normalization❤

@Justhemanth00 7 ай бұрын

Tq very brother 😊 Explanation is too good bro keep going 👏

@My_Dream-hb2dw Ай бұрын

Thank you so much for your crystal clear explanation on normalization...😊

@yukanshub1340 4 ай бұрын

Hi sir .. I watched many videos but ur explanations is very clear thank you so much sir

@vedant_dhamecha 5 ай бұрын

I'm watching 3 days before my Linde Eng Technical Interview thanks man

@user-df7ni7gi1s 4 ай бұрын

highly recomanded guiyes the content is top quality nd eazy to understand 🤝👍

@kranthikumar5016 6 ай бұрын

Thankyou sir for the clear explanation and iam your one of the Student ❤️

@sinekad5132 9 ай бұрын

Thank you so much sir😌😍 clear explanation 🙌👏👏👏

@Entertainment_world_A1468 8 ай бұрын

Super explanation bro ❤I love the way u explained.

@bharathkrishnan365 2 күн бұрын

bro u nailed it after 7 videos i only understood yours bro

@sahilpathan7577 Ай бұрын

Super se upar teaching all doubt clear thanks 😊

@DeepikaMashetty 3 ай бұрын

thank you so much sir , very easily i got all normalization forms

@sirisha2894 5 ай бұрын

Nice explanation and better to understand bro .. thanks a lot

@sumantadky5603 3 ай бұрын

Thank you very much sir... This helped me a lot

@iralapraveen4383 5 ай бұрын

You told Excellently and clearly sir

@kanukuntlaanjali9083 7 ай бұрын

Thank you for the clear explanation sir 😊

@shreyapandey1423 5 ай бұрын

Such an easy explaination😊thanks a lot

@MYBEAUTIFULWORLD123 5 ай бұрын

You are better than my professor man ❤

@namelessmonster8139 6 ай бұрын

You explanation is amazing ❤

@ByteGeniusHub 6 ай бұрын

I finally understood now Thanks!

@shyamalathandu4451 16 күн бұрын

Ur the best lecture sir I have ever seen ❤

@soujanyapanchal1132 10 ай бұрын

Very well explanation sir..🙏

@bhavanareddy3101 2 ай бұрын

your explanation is just awesomeeee....

@jeevangowdaks6416 3 ай бұрын

Best video for normalization thank you sir🙏

@-SAIHARSHITH 6 ай бұрын

Really such a great explanation😩

@akchannel6519 Ай бұрын

thank you sir i liked the video

@daniashakeel29 Ай бұрын

Thnku so so much i see so many videos but finally i got it😭😭

@tavleenkaur3208 8 ай бұрын

Just mind blowing 💗

@shivaniyadav8287 10 ай бұрын

Great explanation sir Thank you

@begavathakhilabegavathakhi2587 7 ай бұрын

Explanation is super brother

@AnilKumar-xs1gx 8 ай бұрын

Wonderful explanation Keep it bro ❤

@abdullahmewawala3412 2 ай бұрын

Great video with easy explanation thanks a lot

@praveenbhajantri7559 3 ай бұрын

Bro u r just amazing 😍😍😍😍

@all__in__one_- 9 ай бұрын

Nicley explained bro👍 i understood everything clearly😁

@karingulapranathi7714 Ай бұрын

Kiraak sir🎉

@user-cn2vn9ul4v 5 ай бұрын

wonderful explanation sir.🙏👏

@spikemza6610 6 ай бұрын

probably the best explanation

@naveenprabhu7210 2 ай бұрын

U r my saviour broo 😭 tomorrow is my sem tnk u so much

@Ravisurya2002 Ай бұрын

Great explanation sir 😊

@user-zn9hx8zr2z Ай бұрын

Jai Hind sir Maaja aa gaya thank you so much,,,,,,,,,,,,

@mehndiby_khushi 4 ай бұрын

Best vedio of normalization 👍

@user-mn5me9tp3c 3 ай бұрын

this is the best teaching..

@leoooo2678 Ай бұрын

Hyy bruh Nina Na Exam iyndhi yes i learned this topic from you and notes thiskuna bruh asal nee Voice hey enapadindhi na exam lo and super rashina bruh thank You So Much For Your Explanation 😊❤️

@kothashivakumar2678 10 ай бұрын

Super explanation sir 😊

@HimanshuKumar-vk1xo 4 ай бұрын

sir you explained it in very detail

@thearyan7 10 ай бұрын

Best explanation sir ❤

@sufiyanahmad3854 8 ай бұрын

Thank you Very much sir ❤

@kbhagyalakshmi6991 6 ай бұрын

Its very use ful brother ❤

@sudhakar4113 2 ай бұрын

Super bro mbind blowing explanation ❤❤❤

@_venus262 8 күн бұрын

Thank you so much brother 😭✨

@rkshorts1829 28 күн бұрын

No one can explain like this ❤

@mounichinthala9011 8 ай бұрын

Thank you so much helped a lot

@sriza1057 5 ай бұрын

best vedio thnku very much

@tjrraja9223 7 ай бұрын

B. Tech lo core subjects pass aythunna ante mee videos valle bro ❤

@sivaprakasamm8608 Ай бұрын

Very good explanation sir..

@pushpasrigatte5596 7 ай бұрын

Super sir nice explanation ☺️

@uet_____boys 2 ай бұрын

luv you u save me luv from Pakistan luv u shera khush rha abad rh

@g.zgamer9055 2 ай бұрын

Thank you very much 🎉

@KotaHaricharanvishnu 8 ай бұрын

super video bro very understandable

@AARONBOBANTHOMAS Ай бұрын

Great explanation bro !!!!!!

@user-it4ut8tj3p 4 ай бұрын

Fantastic teaching sir 👏👏👏👏

@prabhuprabhu1299 2 ай бұрын

Bro tomorrow my sem😭your videos helped me a lot ❤️

@karthikhp893 4 ай бұрын

Thanks brother help full exam

@user-funny894-fun 10 ай бұрын

TQ soo much sir💝

@sujathalaveti 3 ай бұрын

Thankyou so much bro.

@madhuri_killi 8 ай бұрын

Superb explanation

@dmabhishek9194 3 ай бұрын

Clear explanation❤

@sindhub9332 Ай бұрын

Best explanation sir👏

@zainabahmad1249 23 күн бұрын

It means alot sir❤❤❤❤❤

@najiyashaikh1835 7 ай бұрын

Very nice explanation

@CoderHariom 5 ай бұрын

00:02 Normalization is a process of organizing data to reduce redundancy. 02:05 Normalization in DBMS is a progressive method to remove anomalies from the database and bring it to a consistent state. 04:17 Normalization is the process of removing duplicate values and ensuring data integrity in a database 06:27 Table is in 2NF if it is in 1NF and has no partial dependency. 08:35 Normalization in DBMS: Removing partial dependency 10:36 Normalization in DBMS - 3NF 12:41 Normalization in DBMS 14:38 Normalization in DBMS 16:46 To remove multi-value dependency, create separate tables with one non-primary key column depending on one primary key column. 18:37 Fifth normal form ensures no joint dependencies and breaks down tables into smaller subtables. 20:26 Table normalization reduces redundancy and ensures data integrity. Crafted by Merlin AI.