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 ? “

Notes & Slides Link: https://drive.google.com/drive/folder...

Discord Server Link:   / discord  

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

Connect with me here:

Instagram:   / lovebabbar1  
Twitter:   / lovebabbar3  
Telegram Group Link: Love Babbar CODE HELP
https://telegram.me/lovebabbercodehelp

Connect with Lakshay:

Instagram: https://www.instagram.com/lakshayk12/...
LinkedIn:   / lakshay-kumar-368a06146  

My Editor: https://www.instagram.com/rishu.rsing...

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