Lec-20: Introduction to Normalization | Insertion, Deletion & Updation Anomaly

0:00 - Introduction
0:40 - Row level Duplicacy
2:04 - Column level Duplicacy
3:24 - Anomaly
4:04 - Insertion Anomaly
6:05 - Deletion Anomaly
8:04 - Updation Anomaly
11:05 - Normalization

►Database Management System(Complete Playlist):

Other subject-wise playlist Links:
--------------------------------------------------------------------------------------------------------------------------------------
►Design and Analysis of algorithms (DAA):
►Computer Architecture (Complete Playlist):
► Theory of Computation
►Artificial Intelligence:
►Computer Networks (Complete Playlist):
►Operating System:
►Structured Query Language (SQL):
►Discrete Mathematics:
►Compiler Design:
►Number System:
►Cloud Computing & BIG Data:
►Software Engineering:
►Data Structure:
►Graph Theory:
►Programming in C:
►Digital Logic:

---------------------------------------------------------------------------------------------------------------------------------------
Our social media Links:
--------------------------------------------------------------------------------------------------------------------------------------
►For Any Query, Suggestion or notes contribution:

#Normalization#FullConceptNormalization#DBMS#GATE#UGCNET#CollegeUniversityexams

[nirojkhatiwada]

One of the best computer teacher i have ever found ❤

[aryarajank]

I'm a malayali. Usually I watch youtube tutorials in English. Yours is the first Hindi tutorial I watch. Simply superbbbb.. well understood.. Thank you 😊

[buntygirdhar]

finally a decent teacher who teach in both hindi n elglish... very well sir

[vanshikhadhir]

I have no words to explain how good you are at teaching.. i dont know why we are paying to our university.. i guess just for the stress they are giving us for the heavy work load .. work seems easier when taught by the teachers like you sir.. hats off to you….

[manavshah]

You actually prove the word TEACHING to it's best.
Your way of teaching is really great! 🙌

[uranium]

i just want to say, thanks to you for teaching me "coa", "os", and now "dbms" ... your real life examples related to topic .
makes feel the topic ..

[alicodes]

The dislikes are from those University teachers who are jealous of you 😂

[saumyadwivedi]

I have my exam in 1hr, and aapne saare important concepts itni jaldi samjha diye! Tysm! Best channel for last minute revisions!👍🏻

[anshika]

you are such a great teacher that even our college's well qualified lecturers recommend your although, we were already active on your channel before their are a fabulous teacher💯 have made the toughest subject very easy with your explanation hats off🙌

[passgamer]

❤👍 I don't have words to say 😊about this c.teacher seriously 😊sirf 2 min dekha mne or like or subscribe kr diya bina soche 😮 asa m kabhi ni krti😅 omg

[Aryansharma-qmfq]

You are God of students. U deserve millions, billions of subscriber. ❤️❤️

[srishtiinvestments]

Great video just one mistake at 9:16 it should be UPDATE STUDENT SET Sname= 'Amrit Pal' where Sid=4; instead of sid = 2.

[dewangpatil]

BEST EXPLANATION EVER I have watched over 8 to 10 videos of normalization....but this vid was the one where I finally understood. THANKYOU

[haniashehzad]

Can't thank you enough!!
Lots of respect from Pakistan.

[aradhanamurarka]

Sir I've no Words to express my Gratitude to you ✨

[juniorWeb]

best teacher i have seen on youtube for computer sci. Thanku so much for ur very beautiful knowledge

[snoviasarfraz]

Jab ham student the tab bhi apki videos se help lete ha ab ham teacher ha ab bhi apka method follow krte hue teach kr rhe ha thank you soooo much sir g ❤❤❤

[parvesh]

You give very satisfactory explanation in every video.... Thank you for your kind effort 😊🤗

[TheProdSpace]

Didn't understood about updation. In case if f`1's salary is updated in every column what's wrong? It should be updated everywhewe if same faculty is teaching.

[yashmishra]

@5:37 you cannot insert the dummy value because it will create domain constraints .