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

Sdílet
Vložit
  • čas přidán 8. 09. 2024
  • 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

Komentáře • 110

  • @afiamubasshira9985
    @afiamubasshira9985 Před 4 měsíci +6

    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🤩🤩

  • @aartinarotra8301
    @aartinarotra8301 Před měsícem +3

    Seriously mam your explanation is outstanding thankyou

  • @Sahadwipayan
    @Sahadwipayan Před rokem +44

    Actually ma’am kl se mera semester exam start hoga and tomorrow mera dbms ka exam ha so thank you so much ma’am ❤❤❤

  • @ashgaming5785
    @ashgaming5785 Před 3 měsíci +3

    Tomorrow is My paper of DBMS. She is teaching soo well.

  • @aesthetic.javeria
    @aesthetic.javeria Před rokem +9

    Awesome lecture very v informative JAZAKiLLAH mam ❤

  • @i_am_ayan_s11
    @i_am_ayan_s11 Před 6 měsíci +11

    Aj exam h mera 😊

  • @ArcadeNinja01
    @ArcadeNinja01 Před 9 měsíci +3

    Thank you ma'am it's really a good video 😊 I clear all concept

  • @muhammadsaddique242
    @muhammadsaddique242 Před rokem +3

    Great ...beautiful teacher ❤❤❤❤❤❤ Always happy 😊

  • @2li23
    @2li23 Před 3 měsíci

    3 hours waste kr k aya hoon yahan to bs 20 minutes ma hii smj aa gya 😊❤
    Nice video ❤

  • @digitalpanda5969
    @digitalpanda5969 Před rokem +3

    omg app bohot achha explain karte hai thankyou mam

  • @arslanasghar4792
    @arslanasghar4792 Před 9 měsíci +7

    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 Před 3 měsíci +1

      exactly! there should be a table and they should apply all nf to that table to understand it better.

  • @evilqueen3728
    @evilqueen3728 Před 3 měsíci

    Mam You Are Tooo Good Supperb Hatts Of To You Mam.. Thank You So Much.. May Allah Bless You❤

  • @user-ty6hc3np8p
    @user-ty6hc3np8p Před 7 měsíci +2

    One of the best video mam

  • @pankajbhatt7373
    @pankajbhatt7373 Před 2 měsíci +1

    very clearly expalined

  • @AdityaSoni-ss9cq
    @AdityaSoni-ss9cq Před 12 dny

    अच्छी वीडियो

  • @Sahadwipayan
    @Sahadwipayan Před rokem +5

    Thank you so much mama ❤

  • @laxmanpondey
    @laxmanpondey Před 10 měsíci +2

    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

  • @VastuSolutionbyNeeru
    @VastuSolutionbyNeeru Před 4 měsíci +1

    Nice lecture

  • @UmaYadav-si4et
    @UmaYadav-si4et Před měsícem +1

  • @rikeshsahu412
    @rikeshsahu412 Před 2 měsíci

    Better class for normalisation

  • @Khushboo55705
    @Khushboo55705 Před 8 měsíci +1

    Excellent explanation 👌👌👍

  • @user-ki9ul6hp9e
    @user-ki9ul6hp9e Před rokem +1

    nice video i am understand this topic thank mam

  • @user-ec3qn5dv5x
    @user-ec3qn5dv5x Před 4 měsíci

    Thank you mam ❤❤❤

  • @PushpaKumari-pi5mp
    @PushpaKumari-pi5mp Před rokem +2

    Thank you so much ma'am ❤

  • @kirna3245
    @kirna3245 Před 3 měsíci

    👏👏👏👏👏well done

  • @AshutoshKumar-ji3me
    @AshutoshKumar-ji3me Před 2 měsíci

    Thanks mam 😊

  • @bhishamlalmandle5390
    @bhishamlalmandle5390 Před 4 měsíci

    Nice video thank you madam

  • @DevrajSingh-mt3ww
    @DevrajSingh-mt3ww Před 6 měsíci +1

    Nice

  • @isha4050
    @isha4050 Před 3 měsíci

    Thankyou ma'am ❤

  • @shwetarani8607
    @shwetarani8607 Před 4 měsíci

    Ma'am please make video on software testing and visual Basic

  • @deepakkumarsahu8321
    @deepakkumarsahu8321 Před rokem +1

    Mam thank you in these topic all concepts are clear 👍🙏👏🙋🏿‍♂️

  • @SovaMehta
    @SovaMehta Před 2 měsíci +2

    Today my exam...
    And I watch this video 🤣...

  • @shivampawar5887
    @shivampawar5887 Před 6 měsíci

    Bahot badhiya

  • @chmariyamyaseen4705
    @chmariyamyaseen4705 Před 3 měsíci

    great

  • @vivakanandabora9309
    @vivakanandabora9309 Před 9 měsíci

    best video ......

  • @umerkhan4357
    @umerkhan4357 Před 4 měsíci +1

    At ( 17:11 ) In 2NF... I think 1st table should have *_project_id_* instead of *_project_name_* ?

  • @ahmedali3017
    @ahmedali3017 Před 8 měsíci

    Greate mam.

  • @techlakshmiraj5797
    @techlakshmiraj5797 Před 8 měsíci

    Thankyou ❤

  • @muhammadkhan-pl6tq
    @muhammadkhan-pl6tq Před rokem +3

    mam kindly upload some topics on Operating system and data structure

    • @ZeenatHasanAcademy
      @ZeenatHasanAcademy  Před rokem

      All the important topics are uploaded click on channel logo then Playlist then OS and DS

  • @faizazam4256
    @faizazam4256 Před rokem +1

    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  Před rokem

      After 2 nf in second table we can make it foreign key not primary key

    • @faizazam4256
      @faizazam4256 Před rokem

      @@ZeenatHasanAcademy ooo
      Ok Thanks Mam...

  • @amitrajclasses9130
    @amitrajclasses9130 Před rokem +1

    Maam dbms ka pura series padha dijiye join or union all topic maam bahut kripa hogi

  • @user-ik4ml7cj5r
    @user-ik4ml7cj5r Před 7 měsíci

    Nice teach

  • @vinaychakradhari4957
    @vinaychakradhari4957 Před rokem

    Tq maim 🙏🙏

  • @preetgill257
    @preetgill257 Před 4 měsíci

    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  Před 4 měsíci

      Candidates key wah key hai Jo primary key ho sakti thi magar humne use as a primary key select nhi kiya

    • @preetgill257
      @preetgill257 Před 4 měsíci

      Thank you so much mam batane ke liye apka but pta nhi mujhe smj mai aa sa nhi raha hai 😕😐

  • @expertreviews1112
    @expertreviews1112 Před rokem +6

    In 2NF example, shouldn't Student table contain ProjectId instead of Project name?

    • @ani_graphy03
      @ani_graphy03 Před rokem

      Same question

    • @aditisingh2430
      @aditisingh2430 Před rokem

      Same

    • @syedmohammed786y
      @syedmohammed786y Před rokem

      @@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

  • @prithvirajjadhav7039
    @prithvirajjadhav7039 Před 10 měsíci

    mam please make videos on microprocessor

  • @EarnSmartTV540
    @EarnSmartTV540 Před 3 měsíci

    Mam ap bht acha samjati ha plz mera reply kejea ga ma ap ka student ho Pakistan sy lot of love from Pakistan

  • @supercooking4030
    @supercooking4030 Před rokem

    Thanks mam

  • @akanshatripathi9452
    @akanshatripathi9452 Před 4 měsíci +1

    Ma'am Site par notes available nahi hai

  • @Fatima-84
    @Fatima-84 Před 3 měsíci

    👍

  • @ashutoshsrivastava2458
    @ashutoshsrivastava2458 Před 9 měsíci +1

    23:00

  • @DEEN80
    @DEEN80 Před 3 měsíci

    🎉 10:54

  • @user-og8hx5fs4u
    @user-og8hx5fs4u Před 2 měsíci +1

    Mam meine online classes leni hai kindly ap agr online classes leti hain to bta dain.

  • @zeeshanwaheed2792
    @zeeshanwaheed2792 Před 10 měsíci

    i love you mam

  • @deepakkabade6404
    @deepakkabade6404 Před 9 měsíci +2

    Diploma 👩‍🎓student

  • @user-qh7ej2qs1d
    @user-qh7ej2qs1d Před rokem +1

    8:21

  • @uisaurabh1405
    @uisaurabh1405 Před 6 měsíci

    1:34

  • @YourProducts-td9qx
    @YourProducts-td9qx Před 2 měsíci

    `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 Před 2 měsíci

      Bhai ak saal porini video ha kha reply Milly ga 😅😅😂😂😂😂

    • @YourProducts-td9qx
      @YourProducts-td9qx Před 2 měsíci

      @@uniquegamer1268 yr bro umeed py duniya kaim hy 😜

  • @nany-B
    @nany-B Před 4 měsíci

    12:53

  • @KhanSirkamotivationalvideostud

    Aaj mera exam hai 2 baje se😂

  • @ankitsolanki01
    @ankitsolanki01 Před 8 měsíci +3

    Legends watchin before one day of exam

    • @machvlog
      @machvlog Před 6 měsíci

      30 min before watching

  • @BkAryan-gl5ul
    @BkAryan-gl5ul Před 7 měsíci

    25:17

  • @nehasharma5529
    @nehasharma5529 Před 3 měsíci

    Website not exist

  • @abidakhan9829
    @abidakhan9829 Před 2 měsíci

    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  Před 2 měsíci

      Note-The value of the primary key must not be duplicated in any of the tuples of a relation.

  • @DAWOODAHMEDDAWOODAHMED-eo2ez

    today my exams

  • @Guywhocares
    @Guywhocares Před rokem

    Daymn

  • @vaibhavgholap3433
    @vaibhavgholap3433 Před 5 měsíci

    webpage is not loading

  • @misses.Asghar
    @misses.Asghar Před 2 měsíci

    KL.mera exam h

  • @Pramod._.ji.
    @Pramod._.ji. Před 2 měsíci +1

    Who watches in 2024❤❤

  • @anuzex
    @anuzex Před 2 měsíci +1

    Kuch nahi padha 1 ghanta bad exam hai 😌😌

  • @Manjit_Pal7285
    @Manjit_Pal7285 Před 3 měsíci

    Today I have exam 😂

  • @AtankLil
    @AtankLil Před 2 měsíci

    10 min bache hai exam me 😢

  • @gourabsaw7300
    @gourabsaw7300 Před 3 měsíci

    Viva 😂

  • @Khan_33_
    @Khan_33_ Před 3 měsíci +2

    Exam ke 30 minutes pehle 😅

  • @ashutoshacharya7753
    @ashutoshacharya7753 Před měsícem

    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

  • @Rajababuyadav099
    @Rajababuyadav099 Před 4 měsíci

    Thank you mam ❤❤

  • @duniyatv3204
    @duniyatv3204 Před 7 měsíci +1

  • @muhammadkhan-pl6tq
    @muhammadkhan-pl6tq Před rokem

    thanks mam❤

  • @AtankLil
    @AtankLil Před 2 měsíci

    10 min bache hai exam me 😢

  • @DivyeshKanani108
    @DivyeshKanani108 Před 9 měsíci +2

    Thanks ma'am ❤