Types of Normalization in DBMS in Hindi|1NF | 2NF | 3NF | BCNF| 4NF | 5NF in DBMS| With Example

  Рет қаралды 118,226

Zeenat Hasan Academy

Zeenat Hasan Academy

Күн бұрын

Normal Forms in DBMS
Normalization in DBMS
Introduction to Normalization
what is Normalization
What is Normal Form
Types of Normal Form
1NF 2NF 3NF in DBMS
BCNF in DBMS
4NF in DBMS
5NF in DBMS
DBMS Tutorial in Hindi
Normal Forms in DBMS
C++ Top 20 Questions for Theory Exams
BCA
MCA
B.Tech
B.Sc Computer Science
M.Sc Computer Science
C++ PROGRAMMING: • C++ PROGRAMMING
C++ Most Important 20 Questions
C++ for BCA
C++ for MCA
C++ for Computer Science
C++ for BTech
C++ function
Introduction to C++
C++ tutorial in Hindi
Most Important Questions in C Programming
C programming for BCA
C programming for B.Tech
C programming for beginners
C programming
Update command in SQL
Update query in SQL
updating the data in SQL
DML Language
BCA
MCA
Computer Science
B.Tech
Diploma in computer
O level
Class 11 computer science
class 12 computer science
Join this channel to get access to perks:
/ @zeenathasanacademy
jii
Job Alert with Zeenat Hasan click here
/ @jobalertwithzeenathasan
............................................
Telegram- (Zeenat Hasan Academy) t.me/zeenathas...
.............................................
Instagram- (zeenat_hasan_official) / zeenat_hasan_official
............................................................
Facebook Page- (Zeenat Hasan Computer's Subject Learning)
/ zeenat-hasan-computers...
........................................
Twitter- (Zeenat Hasan 4)
Ze...
----------------------------------------
Playlist Computer Architechture
• Binary, Decimal,Octal,...
Live Class of C++ Programming Oct - Nov 2020
• Playlist
C PROGRAMMING
• C PROGRAMMING Full Course
C TOPIC ON DEMAND
• Difference Between voi...
C PROGRAMMING LIVE CLASS
• C Programming tutorial...
C++
www.youtube.co....
Java
• INTRODUCTION TO JAVA ...
JAVA PROGRAM
• SET PATH IN JAVA IN HI...
OOPS CONCEPT
• Object Oriented Progra...
HTML
• INTRODUCTION TO HTML ...
DATA STRUCTURES AND ALGORITHMS
Data Structures And Algorithms for beginners in Hindi: • Data Structures And Al...
COPUTER GRAPHICS
www.youtube.co....
OPERATING SYSTEM
www.youtube.co....
Computer Architechture
• Binary, Decimal,Octal,...
COMPUTER NETWORK
• COMPUTER NETWORK
STUDENT SUPPORT
• BCA Course Detail |wha...
UGC NET Solutions of Computer Graphics
www.youtube.co....
zeenat hasan data structure
zeenat hasan computer graphics
zeenat hasan operating system
zeenat hasan youtube channel
zeenat hasan java programming
zeenat hasan html
computer graphics tutorial in hindi

Пікірлер: 116
@afiamubasshira9985
@afiamubasshira9985 5 ай бұрын
I am from Bangladesh and i am studying in Information Science and Library Management. In 3rd year 2nd semester DBMS course enrolled and my examination will held in 21April. I though i can't do well in this chapter but now after watching this video, OMG it so easy. Tnx mam for such amazing class🤩🤩
@Sahadwipayan
@Sahadwipayan Жыл бұрын
Actually ma’am kl se mera semester exam start hoga and tomorrow mera dbms ka exam ha so thank you so much ma’am ❤❤❤
@parthadebnath701
@parthadebnath701 Жыл бұрын
BCA student?
@jamshaidahmed904
@jamshaidahmed904 Жыл бұрын
Bro same is happening with me in this date and my first exam is of DBMS wish me luck toubro
@jamshaidahmed904
@jamshaidahmed904 Жыл бұрын
Or bootni k loday lag gaye mery😂 Tujnsy update hi nah hopaya 😂
@programinglife.1400
@programinglife.1400 Жыл бұрын
​@@jamshaidahmed904same bro
@SaurabhNegi-b6o
@SaurabhNegi-b6o 10 ай бұрын
Bhi kal to mara bhe ha
@aartinarotra8301
@aartinarotra8301 3 ай бұрын
Seriously mam your explanation is outstanding thankyou
@aesthetic.javeria
@aesthetic.javeria Жыл бұрын
Awesome lecture very v informative JAZAKiLLAH mam ❤
@laxmanpondey
@laxmanpondey 11 ай бұрын
23:40 how is the 2nd table correct??... the zip is a primary key and city becomes non prime...and if we combine them both we get a candidate key...then it just becomes LHS without RHS
@ashgaming5785
@ashgaming5785 4 ай бұрын
Tomorrow is My paper of DBMS. She is teaching soo well.
@CuteSoftie-i5g
@CuteSoftie-i5g 4 ай бұрын
;O
@ashgaming5785
@ashgaming5785 4 ай бұрын
@@CuteSoftie-i5g 🤣🤣
@KhanSirkamotivationalvideostud
@KhanSirkamotivationalvideostud 2 ай бұрын
Mera complete hai dear
@PixelShiv
@PixelShiv 4 күн бұрын
Keep uploading ❤
@muhammadsaddique242
@muhammadsaddique242 Жыл бұрын
Great ...beautiful teacher ❤❤❤❤❤❤ Always happy 😊
@2li23
@2li23 4 ай бұрын
3 hours waste kr k aya hoon yahan to bs 20 minutes ma hii smj aa gya 😊❤ Nice video ❤
@ArcadeNinja01
@ArcadeNinja01 10 ай бұрын
Thank you ma'am it's really a good video 😊 I clear all concept
@digitalpanda5969
@digitalpanda5969 Жыл бұрын
omg app bohot achha explain karte hai thankyou mam
@NehaSundavadra
@NehaSundavadra 20 күн бұрын
Mera ek question hai Aapane bataya tha candidate key super key ko further devide karane par attribute uniquely nahi dikhe vo hote hai lekin yaha BCNF ke example table me to sare colam ke attribute unique hai To ve candidate key kaise ho sakati hai?
@arslanasghar4792
@arslanasghar4792 10 ай бұрын
one example should be use for all NF, in each NF, you are changing the example that's why having some issue to understand
@AliRaza-gh3hp
@AliRaza-gh3hp 4 ай бұрын
exactly! there should be a table and they should apply all nf to that table to understand it better.
@umerkhan4357
@umerkhan4357 5 ай бұрын
At ( 17:11 ) In 2NF... I think 1st table should have *_project_id_* instead of *_project_name_* ?
@samdam478
@samdam478 4 ай бұрын
same doubt
@RiyaThakur-m4i
@RiyaThakur-m4i 8 ай бұрын
One of the best video mam
@evilqueen3728
@evilqueen3728 4 ай бұрын
Mam You Are Tooo Good Supperb Hatts Of To You Mam.. Thank You So Much.. May Allah Bless You❤
@i_am_ayan_s11
@i_am_ayan_s11 7 ай бұрын
Aj exam h mera 😊
@bababhujalvidkosle5343
@bababhujalvidkosle5343 6 ай бұрын
Kl mera
@ultimategoal9555
@ultimategoal9555 5 күн бұрын
Mera bhi aaj hai😂
@mdsaifullah3128
@mdsaifullah3128 7 күн бұрын
Thank you so much mam
@pankajbhatt7373
@pankajbhatt7373 3 ай бұрын
very clearly expalined
@muhammadkhan-pl6tq
@muhammadkhan-pl6tq Жыл бұрын
mam kindly upload some topics on Operating system and data structure
@ZeenatHasanAcademy
@ZeenatHasanAcademy Жыл бұрын
All the important topics are uploaded click on channel logo then Playlist then OS and DS
@shwetarani8607
@shwetarani8607 5 ай бұрын
Ma'am please make video on software testing and visual Basic
@faizazam4256
@faizazam4256 Жыл бұрын
How In 2nf (project id) is primary key because primary key has neither null value nor duplicate value in same table...?? Please Elaborate mam....
@ZeenatHasanAcademy
@ZeenatHasanAcademy Жыл бұрын
After 2 nf in second table we can make it foreign key not primary key
@faizazam4256
@faizazam4256 Жыл бұрын
@@ZeenatHasanAcademy ooo Ok Thanks Mam...
@rikeshsahu412
@rikeshsahu412 3 ай бұрын
Better class for normalisation
@deepakkumarsahu8321
@deepakkumarsahu8321 Жыл бұрын
Mam thank you in these topic all concepts are clear 👍🙏👏🙋🏿‍♂️
@expertreviews1112
@expertreviews1112 Жыл бұрын
In 2NF example, shouldn't Student table contain ProjectId instead of Project name?
@ani_graphy03
@ani_graphy03 Жыл бұрын
Same question
@aditisingh2430
@aditisingh2430 Жыл бұрын
Same
@syedmohammed786y
@syedmohammed786y Жыл бұрын
@@aditisingh2430 if it contains the project id again it would be in the partial dependency form ,we are splitting the prime attributes into two tables to remove partial dependency
@DivyeshKanani108
@DivyeshKanani108 10 ай бұрын
Thanks ma'am ❤
@Khushboo55705
@Khushboo55705 9 ай бұрын
Excellent explanation 👌👌👍
@Sahadwipayan
@Sahadwipayan Жыл бұрын
Thank you so much mama ❤
@amitrajclasses9130
@amitrajclasses9130 Жыл бұрын
Maam dbms ka pura series padha dijiye join or union all topic maam bahut kripa hogi
@GhulamNaseer-x4f
@GhulamNaseer-x4f 4 ай бұрын
Mam meine online classes leni hai kindly ap agr online classes leti hain to bta dain.
@Pushpa-pi5mp
@Pushpa-pi5mp Жыл бұрын
Thank you so much ma'am ❤
@VikashKumar-s5k7q
@VikashKumar-s5k7q Жыл бұрын
nice video i am understand this topic thank mam
@prithvirajjadhav7039
@prithvirajjadhav7039 11 ай бұрын
mam please make videos on microprocessor
@EarnSmartTV540
@EarnSmartTV540 4 ай бұрын
Mam ap bht acha samjati ha plz mera reply kejea ga ma ap ka student ho Pakistan sy lot of love from Pakistan
@ZeenatHasanAcademy
@ZeenatHasanAcademy 4 ай бұрын
Keep learning...Best wishes
@EarnSmartTV540
@EarnSmartTV540 4 ай бұрын
@@ZeenatHasanAcademy thanku so much mam thanku for reply ❤️
@Our_techs
@Our_techs 4 ай бұрын
Acha beta zain
@VastuSolutionbyNeeru
@VastuSolutionbyNeeru 5 ай бұрын
Nice lecture
@AdityaSoni-ss9cq
@AdityaSoni-ss9cq Ай бұрын
अच्छी वीडियो
@shivampawar5887
@shivampawar5887 8 ай бұрын
Bahot badhiya
@preetgill257
@preetgill257 5 ай бұрын
Baki sb bhut ache se smj aa ge ya bhut bdiya mam bs candidate key bna skte the primary jaha se bs mujhe confusion hai bs mam 😐😊
@ZeenatHasanAcademy
@ZeenatHasanAcademy 5 ай бұрын
Candidates key wah key hai Jo primary key ho sakti thi magar humne use as a primary key select nhi kiya
@preetgill257
@preetgill257 5 ай бұрын
Thank you so much mam batane ke liye apka but pta nhi mujhe smj mai aa sa nhi raha hai 😕😐
@PixelShiv
@PixelShiv 4 күн бұрын
Cutie Ma’am ❤ Thanks 🙏
@akanshatripathi9452
@akanshatripathi9452 5 ай бұрын
Ma'am Site par notes available nahi hai
@AshutoshKumar-ji3me
@AshutoshKumar-ji3me 3 ай бұрын
Thanks mam 😊
@techlakshmiraj5797
@techlakshmiraj5797 9 ай бұрын
Thankyou ❤
@bhishamlalmandle5390
@bhishamlalmandle5390 5 ай бұрын
Nice video thank you madam
@DEEN80
@DEEN80 4 ай бұрын
🎉 10:54
@DevrajSingh-mt3ww
@DevrajSingh-mt3ww 8 ай бұрын
Nice
@kirna3245
@kirna3245 4 ай бұрын
👏👏👏👏👏well done
@vivakanandabora9309
@vivakanandabora9309 10 ай бұрын
best video ......
@ahmedali3017
@ahmedali3017 9 ай бұрын
Greate mam.
@ashutoshsrivastava2458
@ashutoshsrivastava2458 10 ай бұрын
23:00
@chmariyamyaseen4705
@chmariyamyaseen4705 4 ай бұрын
great
@vinaychakradhari4957
@vinaychakradhari4957 Жыл бұрын
Tq maim 🙏🙏
@UmaYadav-si4et
@UmaYadav-si4et 2 ай бұрын
@OnlyEdit-z1u
@OnlyEdit-z1u 8 ай бұрын
Nice teach
@SovaMehta
@SovaMehta 3 ай бұрын
Today my exam... And I watch this video 🤣...
@YourProducts-td9qx
@YourProducts-td9qx 3 ай бұрын
`25:31` MADAM AP KEH RAHI HAYN K (STU_ID) PRIMARY KEY HAY JB K [RIMARY KEY CAN NOT BE REPETATIVE OR DSRI BAT IS K BAD AP NY KHA K (HOBBY) IS DEPENDENT ON (STU_ID) & (COURSE) IS ALSO DEPENDENT ON (STU_ID) TO KIA YE TRANSITIVE DEPENDENCY NHI HYY KINDLY IS K BARY ME ZARA BTA DAYN
@uniquegamer1268
@uniquegamer1268 3 ай бұрын
Bhai ak saal porini video ha kha reply Milly ga 😅😅😂😂😂😂
@YourProducts-td9qx
@YourProducts-td9qx 3 ай бұрын
@@uniquegamer1268 yr bro umeed py duniya kaim hy 😜
@supercooking4030
@supercooking4030 Жыл бұрын
Thanks mam
@ArbinShrestha-q8d
@ArbinShrestha-q8d Жыл бұрын
8:21
@uisaurabh1405
@uisaurabh1405 7 ай бұрын
1:34
@nany-B
@nany-B 5 ай бұрын
12:53
@BkAryan-gl5ul
@BkAryan-gl5ul 8 ай бұрын
25:17
@abidakhan9829
@abidakhan9829 3 ай бұрын
4NF mn studentID same hai 101 jb k StudentID same nhi hota its unique nubr ..ap ny double kya hai yh glat hai k theek
@ZeenatHasanAcademy
@ZeenatHasanAcademy 3 ай бұрын
Note-The value of the primary key must not be duplicated in any of the tuples of a relation.
@Fatima-84
@Fatima-84 4 ай бұрын
👍
@ankitsolanki01
@ankitsolanki01 9 ай бұрын
Legends watchin before one day of exam
@machvlog
@machvlog 7 ай бұрын
30 min before watching
@deepakkabade6404
@deepakkabade6404 10 ай бұрын
Diploma 👩‍🎓student
@zeeshanwaheed2792
@zeeshanwaheed2792 11 ай бұрын
i love you mam
@nehasharma5529
@nehasharma5529 4 ай бұрын
Website not exist
@vaibhavgholap3433
@vaibhavgholap3433 6 ай бұрын
webpage is not loading
@KhanSirkamotivationalvideostud
@KhanSirkamotivationalvideostud 2 ай бұрын
Aaj mera exam hai 2 baje se😂
@Guywhocares
@Guywhocares Жыл бұрын
Daymn
@DAWOODAHMEDDAWOODAHMED-eo2ez
@DAWOODAHMEDDAWOODAHMED-eo2ez 3 ай бұрын
today my exams
@misses.Asghar
@misses.Asghar 3 ай бұрын
KL.mera exam h
@Pramod._.ji.
@Pramod._.ji. 3 ай бұрын
Who watches in 2024❤❤
@anuzex
@anuzex 3 ай бұрын
Kuch nahi padha 1 ghanta bad exam hai 😌😌
@SujalBisht8103
@SujalBisht8103 3 күн бұрын
69 minutes left 🎉
@AtankLil
@AtankLil 3 ай бұрын
10 min bache hai exam me 😢
@Manjit_Pal7285
@Manjit_Pal7285 4 ай бұрын
Today I have exam 😂
@gourabsaw7300
@gourabsaw7300 4 ай бұрын
Viva 😂
@Khan_33_
@Khan_33_ 4 ай бұрын
Exam ke 30 minutes pehle 😅
@nikhilbadgujar3379
@nikhilbadgujar3379 4 ай бұрын
Us bhai
@ashutoshacharya7753
@ashutoshacharya7753 2 ай бұрын
mam i think your 2nf is wrong.Because sname which is non unique value is only dependent on student id hence project id is irrelevent.Suppose by roll number we can find the student name then why in the world we require project no?so we need different table to student id and student.Please address that
@RadhikaKumari-n8c
@RadhikaKumari-n8c 5 ай бұрын
Thank you mam ❤❤❤
@isha4050
@isha4050 4 ай бұрын
Thankyou ma'am ❤
@duniyatv3204
@duniyatv3204 8 ай бұрын
@muhammadkhan-pl6tq
@muhammadkhan-pl6tq Жыл бұрын
thanks mam❤
@AtankLil
@AtankLil 3 ай бұрын
10 min bache hai exam me 😢
@Rajababuyadav099
@Rajababuyadav099 6 ай бұрын
Thank you mam ❤❤
Watermelon magic box! #shorts by Leisi Crazy
00:20
Leisi Crazy
Рет қаралды 105 МЛН
إخفاء الطعام سرًا تحت الطاولة للتناول لاحقًا 😏🍽️
00:28
حرف إبداعية للمنزل في 5 دقائق
Рет қаралды 66 МЛН
Кәсіпқой бокс | Жәнібек Әлімханұлы - Андрей Михайлович
48:57
Officer Rabbit is so bad. He made Luffy deaf. #funny #supersiblings #comedy
00:18
Funny superhero siblings
Рет қаралды 18 МЛН
2NF || SECOND NORMAL FORM IN DBMS WITH EXAMPLE
4:35
Crack Concepts
Рет қаралды 344 М.
E-R diagram | DBMS Tutorial in Hindi| ZeenatHasanAcademy
20:32
Zeenat Hasan Academy
Рет қаралды 237 М.
Lec-25: Third Normal Form in dbms with examples in Hindi | Normalization
16:26
1st, 2nd and 3rd Normal Form (Database Normalisation)
11:42
Learn Learn Scratch Tutorials
Рет қаралды 440 М.
Watermelon magic box! #shorts by Leisi Crazy
00:20
Leisi Crazy
Рет қаралды 105 МЛН