Тёмный

Normalization in DBMS | Normal Forms in DBMS - 1NF,2NF,3NF,BCNF and 4NF | DBMS 

SB Tech Tuts
Подписаться 65 тыс.
Просмотров 187 тыс.
50% 1

Normalization : It is the process of evaluating and correcting table structure to minimize data reducing, there by reducing data anomalies.
Normalization works through a series of stages called as normal forms.
1NF
2NF
3NF
BCNF
4NF
Subscribe my channel : www.youtube/SBTechTuts
#normalization
#DBMS
#RDBMS
#SBTechTuts
Normalization in DBMS | Normalization - 1NF,2NF,3NF,BCNF and 4NF
what is normalization
what is normalization in dbms
normalization in dbms
normalization in dbms in telugu
what is normal form
in telugu
by sudhakar bogam
sb tech tuts
normalization in dbms
Normalization in DBMS | Normalization and Normal Form - 1NF,2NF,3NF,BCNF and 4NF
Normalization in DBMS | Normal Forms in DBMS - 1NF,2NF,3NF,BCNF and 4NF
Normalization in DBMS | Normal Forms in DBMS - 1NF,2NF,3NF,BCNF and 4NF | DBMS
database management system
normalization in dbms
database management
dba in dbms
advantages of dbms
relational database management system
types of dbms
types of data models

Опубликовано:

 

26 сен 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 172   
@reballianusha2758
@reballianusha2758 3 года назад
Crystal clear explanation of the concept sir .... No need to search any other videos regarding this concept as it was cleared in this class itself ... Thank u sir 😊
@attitudeboy2840
@attitudeboy2840 2 года назад
Thank you sir.. ofter 3 days we have b tech DBMS exam i follow your channel... And learn everything. Thank you sir.. 💬💌
@SBTechTuts
@SBTechTuts 2 года назад
thank u and welcome to our channel
@reballianusha2758
@reballianusha2758 3 года назад
@SB tech tuts .... this channel always becomes source to study at this sudden exams time ... thank u sir
@jaanu-jk5xs
@jaanu-jk5xs Год назад
Meedhi okka vedio chusthe chaalu Sir వెంటనే subscribe cheseyachu 👌👌👌
@kpaparaokolli8921
@kpaparaokolli8921 2 года назад
Nice examples "robot, Sana, chitti"😂
@sakethphaneendra5447
@sakethphaneendra5447 Год назад
21:07 BCNF CONCEPTS 27:31 4th Normal Form
@AnithaAnitha03
@AnithaAnitha03 Год назад
Thank you sir.. Today Nenu 4rth sem exam manchiga rasanu.. Because of I am following your videos
@SBTechTuts
@SBTechTuts Год назад
thank u and welcome to our channel
@arjun24264
@arjun24264 2 года назад
Super explanation sir Keep it up sir Thank you very much sir 🙏🙏🙏
@deshabhaktudu1884
@deshabhaktudu1884 9 месяцев назад
thank you Akhanda sudhakar simha reddy bhagavanth Kesari sir... Jai Balayya
@vaddeboinaswithika1248
@vaddeboinaswithika1248 3 года назад
Well explained sir... thank you!!
@sushmithasharma7298
@sushmithasharma7298 3 года назад
Your explanation is good sir and easy to understand 👍
@darlingdevendra2544
@darlingdevendra2544 2 года назад
BCNF ki 1NF example teskovachu kadha sir simple understand undedhi 😊....
@lavanyasharma4949
@lavanyasharma4949 Год назад
Hi sir, Trigger topic plz..
@anarayana2103
@anarayana2103 2 года назад
In 1st normal form u selected primary key as r.no But r.no having repeated value hw u selected that as pk
@SBTechTuts
@SBTechTuts Год назад
in 1st normal form just assume which attribute is suitable for primary key...
@sarikaparu
@sarikaparu Год назад
Thank you very much sir, so clearly explained. God bless u
@maheshwaralavenakatanandin7897
@maheshwaralavenakatanandin7897 2 года назад
Sir , ur explaination is nice but enka dbms lo Anni. Topics explaination videos upload cheyandi plzz as soon as possible
@veenanayani3558
@veenanayani3558 3 года назад
Hi sir your explanation simply super and easy understanding,sir could you post some more videos on DBMS concepts in this only related SQL have but I want on DBMS plz could you post
@SBTechTuts
@SBTechTuts 3 года назад
sure.....
@yakaiahpanduga1704
@yakaiahpanduga1704 Год назад
We can understand easily by seeing this channel sir
@m.gowthami429
@m.gowthami429 3 года назад
Good explanation sir understand well thank you
@bhavanikolipyaka5728
@bhavanikolipyaka5728 2 года назад
Thank you sir .... Chala easy ga understand ayyela explain chesaru ... Chala usefull avthundi...
@LALITHPALAGUMMI
@LALITHPALAGUMMI Месяц назад
Thank you, sir! It came in handy.😊
@pogalanaresh4030
@pogalanaresh4030 2 года назад
Sir your explanation is very nice❤️
@sheemaunnisa6068
@sheemaunnisa6068 Год назад
Can't Understand Your Language. But Seeing That Answer in Easy Sentence I can Prepare Well ☺️
@subhashvangari6242
@subhashvangari6242 Год назад
Nice names sir robo sana chitti
@lavanyabilla668
@lavanyabilla668 2 года назад
Unit wise long and short important questions petadi sir please
@SBTechTuts
@SBTechTuts 2 года назад
yes thappakunda peduthanu...
@lavanyabilla668
@lavanyabilla668 2 года назад
@@SBTechTuts sir plz important questions petadi sir
@swapnalavte2033
@swapnalavte2033 3 года назад
Easy and simple explanation sir👍🏻
@bhavanikolipyaka5728
@bhavanikolipyaka5728 2 года назад
Disadvantages of DBMS video cheyandi sir ...
@mudethulaakhil8767
@mudethulaakhil8767 Год назад
Thank you sir
@praveentummapudi7578
@praveentummapudi7578 Год назад
sir you said bcnf satisfies 4nf how to know it is satisfied sir
@shaikmohammed9981
@shaikmohammed9981 Год назад
Good explanation👏🏻👏🏻👏🏻👏🏻👏🏻
@saiyashwanth6151
@saiyashwanth6151 2 года назад
Thanks a ton for your explanation sir
@harshapamulaparthi4682
@harshapamulaparthi4682 2 года назад
Thank you Saving my time
@ajayjayadhar
@ajayjayadhar Год назад
this video is more helpful to us thank you sir
@bunny-iz5cy
@bunny-iz5cy Год назад
Tq so much sir for your ideal explanation 🙌
@Lalli2824
@Lalli2824 5 месяцев назад
Tq sir
@uddagirishivani484
@uddagirishivani484 Год назад
Sir 3nf bcnf 4nf 5nf definations cheppandi sir plzz exams unnay argent sir plzz reply sir
@dhivyah8753
@dhivyah8753 2 года назад
Thank you sir ☺️
@sivareddy3745
@sivareddy3745 Год назад
your way of Teaching is very nice.
@padalajyoshna4045
@padalajyoshna4045 Год назад
Ur explanation is too gud sir
@priyankamodawath6197
@priyankamodawath6197 Год назад
thank you so much sir wonderful explanation🥰
@pavankumarstechcircle9693
@pavankumarstechcircle9693 Год назад
Hi why language known is being removed in 2NF . When it is unique to each student .. how is it not connected to roll number . Kindly tell me please.
@purvipakyala6407
@purvipakyala6407 6 месяцев назад
thaank uh sir
@srikethireddy
@srikethireddy Год назад
Super explanation sir Tq soo much
@sirisiri813
@sirisiri813 2 года назад
Tnq soo much sir for explaining it so easy
@nagajyothi3556
@nagajyothi3556 Год назад
Thank you sir from vision college
@harshapamulaparthi4682
@harshapamulaparthi4682 2 года назад
Thank you soo much for saving my time
@user-MalgasMallesh
@user-MalgasMallesh 2 года назад
👌🏻 Explain Sir..
@vnrvvv9566
@vnrvvv9566 2 года назад
html videos cheyandiyandi
@gorle.bhavanigorle.bhavani4108
@gorle.bhavanigorle.bhavani4108 2 года назад
Thank you sooo much sir naku exam lo chala bhaga help indhi mi explaination vere level🙏🏻🙇🏻‍♀️🙇🏻‍♀️
@SBTechTuts
@SBTechTuts 2 года назад
thank u and welcome to our channel
@agentpskyt5202
@agentpskyt5202 Год назад
Thank you 😊
@mularamakrishna247
@mularamakrishna247 Год назад
Super explanation sir
@sravanichinna158
@sravanichinna158 2 года назад
Baga explain chesaru sir thanks so much
@SBTechTuts
@SBTechTuts 2 года назад
thank u and welcome to our channel
@believer9509
@believer9509 2 года назад
Sir how could you say that table completely in standard form how should we identify that ??meeru 3NF dhaka standard form antunnaru how??? 3NF ki BCNF ki connection vundadha??
@SBTechTuts
@SBTechTuts 2 года назад
complete normal forms check cheyali..... amina errors unte remove cheyali... so manam thiskunna example lo 3nf varaku... anni errors elimenated... bcnf and 4nf unde rules kuda over... bcnf : it is a special of 3nf and every key is a candidate key
@sujathach1396
@sujathach1396 2 года назад
Good morning sir 2NF lo group table lo reputation vachindi kada sir. I mean rno primary key kada sir. Pls clarify sir.
@anilkasindula920
@anilkasindula920 Год назад
Tq very much sir
@prathapcme344
@prathapcme344 Год назад
Excellent sir
@pavithrakomma6549
@pavithrakomma6549 2 года назад
Crystal clear sir.. Ur videos are the best for beginners
@SBTechTuts
@SBTechTuts 2 года назад
thank u and welcome to our channel
@k.sahithi5286
@k.sahithi5286 2 года назад
Sir decomposition using functional dependency ante anti. Please reply sir
@SBTechTuts
@SBTechTuts 2 года назад
decomposition ante removing various error from table and form well defined table... ie normalization.
@hemanth3325
@hemanth3325 3 года назад
Tq sir easy to understand 🤩
@rajuramu1761
@rajuramu1761 Год назад
Sir your teaching is good
@iswaryakurmadasu7637
@iswaryakurmadasu7637 Год назад
Good explanation sir....😊
@Premsagarkashavena
@Premsagarkashavena Год назад
Sir,thanks for your videos.I have one doubt,in 2 NF how we can say that the "language known" column is not depended on "RNO" column.Can you please explain it clearly&by the by please give some more clarity about candidate key.I hope you will reply back
@SBTechTuts
@SBTechTuts Год назад
minimum super key is a candidate key..... watch types of keys video in playlist
@Premsagarkashavena
@Premsagarkashavena Год назад
@@SBTechTuts sir thanks a lot
@saikiran3678
@saikiran3678 2 года назад
Great explanation sir
@shreyasangu3992
@shreyasangu3992 Год назад
Clear cut explanation
@sravanikommu8920
@sravanikommu8920 3 года назад
Super explanation sir tq sir
@teja2581
@teja2581 2 года назад
Sir miru chepindhi exam lo rasthe 10m vesthara svu tirupati
@kishankittu8815
@kishankittu8815 Год назад
sir name ki group ki yala transtive dependency yanduku vundadu
@SBTechTuts
@SBTechTuts Год назад
prathi group lo same name tho student undochu ga.... example bsc, bcom, ba, btech... lo same student name undochu.....
@kishankittu8815
@kishankittu8815 Год назад
Okk sir
@bajiyadav9289
@bajiyadav9289 2 года назад
Tqs bro
@kunchalavenkatrao4059
@kunchalavenkatrao4059 Год назад
Clear cut explanation sir
@pavankarantotu5335
@pavankarantotu5335 2 года назад
Thank you so much sir ❤️
@saikumarreddy9991
@saikumarreddy9991 2 года назад
Sir can u pls post videos on Query processing and Query Optimization Pls reply sir
@bhanuraipally735
@bhanuraipally735 2 года назад
Explain like a robosir
@vikarabadkaavishnu801
@vikarabadkaavishnu801 Год назад
Super explanation sir thank you sir 👌👌👌👌
@k.sahithi5286
@k.sahithi5286 2 года назад
Sir procedural query language ante anti
@moneymaker332
@moneymaker332 2 года назад
Can you change your green pen to red
@madhusureshbabu7440
@madhusureshbabu7440 2 года назад
Super sir..
@sampoorna375
@sampoorna375 9 месяцев назад
Super sir😊 explanation 👍
@SBTechTuts
@SBTechTuts 9 месяцев назад
thank u and welcome to our channel
@247k.soumya9
@247k.soumya9 Год назад
Sir sem 4 anni topics cheyaledhu cursors,triggers etc 5th lo anni topics cheyadi sir videos. I will understand only ur videos sir
@SBTechTuts
@SBTechTuts Год назад
sure thappakunda chesthanu...
@GovardhanReddy-hv5ko
@GovardhanReddy-hv5ko Год назад
Sir degree 3rd sem lo Eh answer rayochaa 10 marks ki
@SBTechTuts
@SBTechTuts Год назад
yes
@saisirajmallipeddi784
@saisirajmallipeddi784 Год назад
Super sir ❤️✨
@anjaiahnarva722
@anjaiahnarva722 2 года назад
Sir can u explain the window functions in sql .I have interview this week. It's very usefull to me to prepare well
@kumari5931
@kumari5931 10 месяцев назад
Sir view serialisation and conflict serialisation topics meedha video chesi upload cheyandi sir please I have a semister exams on 16 December in the year.share that video as soon as possible sir please
@swathigoriparthi7955
@swathigoriparthi7955 9 месяцев назад
DBMS most important questions cheppandi sir e month ending lo exams plz ra
@vvrrteluguvideos2090
@vvrrteluguvideos2090 2 года назад
Sir python neruchukuna sir python DBMS or My SQL yedhi manichidhi sir
@mudavathsipai9851
@mudavathsipai9851 2 года назад
Hai sir 1nf 2nf 3nf and Bcnf definitions chappadi sir plz 🙏🏽🙏🏽
@charantej1817
@charantej1817 2 года назад
👌
@SudeepKasetty
@SudeepKasetty 8 месяцев назад
super sir your teaching is awesome
@RaviGayatri-in1dx
@RaviGayatri-in1dx 9 месяцев назад
sir,in BCNF why u take the section and subject both are primary key
@SanthoshKumar-xs7bb
@SanthoshKumar-xs7bb 2 месяца назад
Sir perfect explanation sir
@VaruntejaSaini
@VaruntejaSaini 4 месяца назад
Sir BCNF lo Physics Raju sir Robo kadu
@pavankumarstechcircle9693
@pavankumarstechcircle9693 Год назад
Hi Sir I have a doubt in 2NF . Why is language known being removed, why is it independent. Because the language known is unique to my roll number only .. since name might repeat . Please explain sir I've exam in a day. Why language known is partial dependency ? It's unique to each student.
@SBTechTuts
@SBTechTuts Год назад
language known is a non key attribute... which is not depend on rno.. so we need to separate...
@Harsha_mudhiraj
@Harsha_mudhiraj 5 месяцев назад
Thank you sudhakar sir ❤
@reddyshekar9568
@reddyshekar9568 2 года назад
Fresher ki sql nurchukunte saripothudana Leda pl/sql nerchukovala sir
@samalarashi7924
@samalarashi7924 3 года назад
Nice explaination sir
@kathyayanirevalla9180
@kathyayanirevalla9180 8 месяцев назад
Could you please do videos on operating system sir..
@vidyadharrao1894
@vidyadharrao1894 Год назад
Thank you Saar❤️🌚
@harshabayyaram
@harshabayyaram Год назад
🎉👍👍👏
@krishnagangumalla7775
@krishnagangumalla7775 Год назад
Sir rajini kanth sir yemoo 🤙🤙😂
@0o0-v9m6w
@0o0-v9m6w 2 года назад
👍
@bharathkumar4087
@bharathkumar4087 6 месяцев назад
4th Normal Form lo tables names ivvaleru sir
@gudapallirambabu2380
@gudapallirambabu2380 2 года назад
Sir object orientation data model ques
Далее
🎙ПЕСНИ ВЖИВУЮ от КВАШЕНОЙ
3:05:21
Новая BMW 5 провал за 10 млн! ИЛИ?..
32:07
Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF
28:34
Normalization in dbms || Dbms in telugu
9:46
Просмотров 224 тыс.
Functional Dependency in DBMS
8:46
Просмотров 27 тыс.