Lecture 11: Why We Need Normalisation ? || DBMS Series for Placements

This Video gives a complete understanding of Normalisation in one Video.

There is a lot to learn, Keep in mind “ Mnn bhot karega k chor yrr apne se nahi hoga ya maza nahi aara, Just ask 1 question “ Why I started ? “

Do provide you feedback in the comments, we are going to make it best collectively.

Connect with me here:

Telegram Group Link: Love Babbar CODE HELP

Connect with Lakshay:

Timestamps:

00:00 - What is Functional Dependency?
11:00 - Armstrong's Axioms
18:30 - Why Normalisation is necessary?
20:00 - Anomalies due to redundant data
22:00 - Insertion Anomaly
25:00 - Deletion Anomaly
26:30 - Updation Anomaly
31:10 - What we actually do in Normalisation?
33:12 - Types of Normal Forms
33:15 - 1NF
35:55 - 2NF
44:45 - 3NF
50:00 - BCNF

Intro Sequence: We have bought all the required Licenses of the Audio, Video & Animation used.

#DBMSBusted #LoveBabbar #Lakshay

[TheBaljitSingh]

47:51 pe yaha ye B->C (c prime attribute kaise ho ja raha

[lokeshnegi]

all those topics were like so tough during cllg days but u made it so much easier thank u so much.

[khanalnischal]

00:00 - What is Functional Dependency?
11:00 - Armstrong's Axioms
18:30 - Why Normalisation is necessary?
20:00 - Anomalies due to redundant data
22:00 - Insertion Anomaly
25:00 - Deletion Anomaly
26:30 - Updation Anomaly
31:10 - What we actually do in Normalisation?
33:12 - Types of Normal Forms
33:15 - 1NF
35:55 - 2NF
44:45 - 3NF
50:00 - BCNF

[ArpitAgrawal-nruc]

Examples helped a lot, I did not find a better explanation than this on YouTube. Thanks

[ChintuCodes]

i have completed this whole series a month ago and now i'm here again just to revise the concepts for my sem examss. lakshay bhaiya literally nailed this complete series muuch love

[imnotakash]

47:50 bhaiya aapne bola hai ki non - prime attribute should not find no-prime attribute but aapne explain krte time bola ki ek non-prime attribute determine the prime attribute

[leekhnna]

Waiting for next videos bhaiya, my placement season is going on, and i am mostly dependable on this series for dbms .. !!

[autismo]

THANKS A LOT FOR THIS SERIES GUYS. REALLY HELPED. 🙏🙏

[prateeksomani]

56:30 . There is redundancy in the Professor table, Since, A non-prime attribute (Professor) can determine another non-prime attribute (Subject) as there is constraint, " Each professor will teach only single subject " and only P-id is the Primary Key. Please Explain this or Correct me if I am wrong.

[sadaf_r]

well explained...i completely understood this normalisation concept...thank a lot brother.

[rituraj]

56:30 student table me s_id PK kaise ho skta hai because it should be unique and NOT NULL?

[sukhjitsingh]

thanks for this DBMS series video Sir and expecting the DP series to come with more videos soon...

[worldofficials]

55:00 sir in student prime attribute (id), how it can detetmine 101 and 102

[ayushp]

Thank you bhaiya for your efforts and your explanation is the BEST❤

[dhananjay]

Great Teaching Method Bhaiyya
Sab samaz mei agaya

[shubhammishra]

Thank you for the lecture, it really helped me a lot. Wonderful work.

[instaflicksu]

56:30, but here in professor's table, professor(no-prime) attribute can determine subject(non-prime) attribute, thus it's not following 3NF, right??

[lalit-singh-bisht]

56:45 there we can get the subject_name from professor meaning nonprime ->nonprime, isn't that a redundancy

[gamingmarvelz]

Explained so clearly with examples❤, just got better idea in dbms which i wasn't when i learned it in clg1 year back

[ShubhamDas-jskx]

at 56:08 in student table id (prime attribute ) having redundant values {101, 101} which is not allowed in prime attribute how we can remove redundancy from here..