Lec-27: BCNF Always Ensures Dependency Preserving Decomposition?? Normalization Examples

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

[rohitn]

Guys, watch till lecture 33 to understand this video

[subrahmanyah]

Really, I should have attempted or watched this channel before. Never mind, it's not that late just the third semester is about to complete UG the second year. Whatever the teaching helps a lot. This also helps me score well in my semester exams.

[webcoder_vlogs]

Indian best YouTuber Teacher Award goes to varun bhaiya 🔥🔥

[hardik]

Thanks a lot sir.!!! I was waiting for this topic, pls do continue to cover some left over topics

[rahulra]

Sir ye wali dependency to 2nd normal form me bhi nhi hoga na kyuki 2nd NF says that: their must not be any partial dependency.. and if BD is a candidate ki then, no FD must not be dependented on either B or D separately... Aur ider to A, D pr dependented hai.. to ye to 2nd nf me bhi nhi hogi.

[RahulbharadwazDeevi]

if BCNF is a sub category of 3NF, then how is it possible that 3NF ensures dependency preserving decomposition but BCNF does'nt preserve dependencies

[sumanghosh]

In this video you have shown that 3nf is not 'dependency preserving decomposition' but your headline is Third Normal form always ensures 'Dependency Preserving decomposition'

[abhishekagrawal]

Hi Sir, Thanks for the video, really explained well. revised the normalization concept as well!!

[siddharthmohanty]

sir, i have endsem exam tomorrow on dbms.im going to start watching all of your vids.if i pass by just studying 24hrs from ur vids.i will call you daddy and i will forever be in your debt <3

[asadjamal]

DA ka alg table bnaya tho BCD table my B q lika???

[rishipandit]

sir if we will watch your dbms playlist full then will we able pass the college exam 2nd year

[unitystudio]

Aslamualikum sir
Sir you are really amazing teacher slute to you

[afzal]

sir thoda structured way me bataya kro kuch samajh nhi aa rha khn se start kya kr rhw ho

[suvankar]

Sir HADOOP big data ke upar full video please...

[shoot]

Sir, ur 'Ji' reminds me of Diljit Dosanjh's 'Ji..Ji' in GOOD NEWWZ movie🤣😂. Jokes apart, excellent lecture sir

[_abhinandanshukla]

Sir please make a videos on Data mining and Warehouse

[ashishkumardas]

Sir, I have a doubt!
If there are two dataset A and B. A having 100 observations and B having 80 observations. Then what will be the output if we use left join and inner join into it.

[yugashmita_charms]

Sir plz take a class on NP, NP complete, hard

[shekhargigras]

one issue i'm facing how in last D is the determinant. because vo to BD dono milkar ban raha hai. to candidate key vo ho ni chahiye.

[shashankjoshi]

Sir jo last year nielit ka course tha uske video chal nhi rhe hai Aap toh bol rhe the kbhi bhi dekh sakte ho