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/folders/1vJuJLGSskrNM29z9SgJMg3NfX7CuPjvm?usp=sharing Discord Server Link: https://discord.gg/feSQvVXMrd Do provide you feedback in the comments, we are going to make it best collectively. Connect with me here: Instagram: https://www.instagram.com/lovebabbar1/ Twitter: https://twitter.com/lovebabbar3 Telegram Group Link: Love Babbar CODE HELP https://telegram.me/lovebabbercodehelp Connect with Lakshay: Instagram: https://www.instagram.com/lakshayk12/?hl=en LinkedIn: https://in.linkedin.com/in/lakshay-kumar-368a06146 My Editor: https://www.instagram.com/rishu.rsingh/?hl=en 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