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

[@TheBaljitSingh]

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

[@the_sky_fire]

C prime nahi non-prime attribute he hai...Bhaiya ne galti se boldiya ...Next dekho jab 3NF convert karenge ...B is Prime attribute determining C (non-prime attribute). Aage Video me dekho 50:40 se 50:54 tak he will mention correctly tab B->C non-prime to non-prime hatana hota hai bolke.

[@lakshaykumar7518]

Thanks Akash for the clarification :) It was a miss!

[@the_sky_fire]

@@lakshaykumar7518 Thank you Bhaiya for Considering and pinning it to the top.

[@TheBaljitSingh]

@@the_sky_fire aachna bhiya ne aage cover kiya hai.. mai confuse ho gya aur yahi pe video rok ke sochne laga.. but bhiya ko thanks for pinning my comment

[@dreamy4174]

Can anyone suggest a video on how to find normal form

[@khanalnischal1488]

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

[@subhajitdey135]

Thanks brah

[@ompat1l]

background mai cat ka timestamps bhi dawdle

[@lokeshnegi5051]

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

[@sadaf_r]

true that

[@ArpitAgrawal-nr7uc]

Examples helped a lot, I did not find a better explanation than this on KZbin. 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

[@prateeksomani9239]

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.

[@anshumaan1024]

yeh toh mene bhi nhi dekha, fir toh yeh example, BCNF nhi hoga, kyoki yeh 2NF hi nhi hai 🤔

[@gamingmarvelz1504]

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

[@leekhnna9808]

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

[@OmkaraEditz]

56:42 yaha pe professor->subject also exists so the 3NF condition is violated??

[@autismo1969]

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

[@lalit-singh-bisht]

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

[@DeepakKumar-xj4ul]

both student_id , subject has take as primary key hence non prime attribute is determining prime attribute which comes under 3NF. see again in video.

[@sukhjitsingh959]

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

[@sadaf_r]

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

[@ayushp4471]

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

[@tusharverma4202]

At 16:04, Can we not do it like this? CD->E, and E->A thus CD->A (using transitive property.) Now, we have BC->A thus BC->B (from 1st relation). Then using reflexive property, as B is a subset of BC, we have a trivial functional dependency.

[@divyangdheer7292]

+1

[@aakash_jamadar939]

you are going vice versa of the Reflexive property,it need not be true.

[@shubhammishra324]

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

[@nitesh.0110]

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

[@vinayjangra1401]

yeah, i also thought that, you are right

[@tusharverma4202]

I think Professor id shouldn't appear in the tables and Professor should become P.K in that table.

[@anuj_pandey]

@@tusharverma4202 then partial depencency b/w p_id and subject would exist

[@AmanGangrade]

also using professor you can find pid which not full fill bcnf

[@MuhammadAsif-xe7es]

Not possible bcoz professor can teach only one subject but subject belongs to the multiple professors Thus you can't find subject with a professor's name.

[@krishraj1942]

16:00 pe B--> C is possible

[@divyangdheer7292]

+1

[@im_simarjeet]

NO not possible

[@UECAshutoshKumar]

Thank you 😊

[@ChintuCodes]

46:34 how c is fully determined by PK ?? since the PK of the table is A whereas C is determined by B. I know A->B but i think B->C should be a partial dependency

[@amanrubey]

Lakshay Sir is like God to me

[@ShubhamDas-js2kx]

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

[@anshumanrout2739]

ya that's a clear mistake , ek bachha do teacher se kaise padh sakta hai .

[@tusharverma4202]

1NF bhi nhi ye table.

[@dhananjay7937]

Great Teaching Method Bhaiyya Sab samaz mei agaya

[@0708Sunshine]

Thank you for all the effort. It is highly appreciated

[@saurabhkumarsingh9550]

BCNF is not clearly taught.

[@Amit_iPhone_shorts]

At 41:37 B kaise determine kri hai c ko in 2NF realtion 2. B to null hai A --> C Hona chaiye na .

[@0xhans]

we make B a primary key in another table, then we can't set it to null.

[@kailanirochellla2006]

aap jaies teacher aur god student ke liye ek saman hote hai love you CodeHelp - by Babbar ❤❤❤❤❤❤✔✔

[@worldofficials9532]

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

[@VishalSharma-zu2vp]

Thanks For Teaching DBMS ❤️

[@akash-jpeg]

Day 11 - Present Sir❤

[@rituraj8630]

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

[@divyanshujindal8673]

56:08 pe jo BCNF ke baad 2nd table h(Professor) usme 2NF toh abhi bhi exist kr rhi h kyunki professor(non prime) se subject(non prime) could be calculated. can anyone explain ?

[@anshumanrout2739]

professor yahan non prime hai . And you are correct . The non prime is determining non prime , which is the case of 3NF and also 2NF . The solution should be either pid hatado aur professor ko prime kardo ya professor name hi hatado

[@sanskrutishahu517]

Yeah correct And start mai hi PK stu_id aur Proff aayega not {stu_id,subj} so BCNF wala case banega hi nhi but usme 2NF wala case hojayega of partial dependency

[@himanshigarg1431]

there is a white cat in his background 6:46....thank you sir for lecture

[@dhruvarora8136]

Bhaiya ek telegram channel ka discuss group bnado

[@aaravkumar1308]

Amazingly well explained . Thanks a lot Lakshay Bhaiya ..>

[@sureshsodha4737]

Sir,how to company decides package during the placement?

[@shubhambarange]

The way of explanation is very amazing

[@prakhargupta4320]

if a is subset of b does not imply that their intersection is zero A -> ABC here ABC is not a Subset of A and intersection is non zero as well in what category will we put it trivial or non trivial

[@ASMR-bu8qc]

In 2NF, all the non-prime attributes must depend on prime attributes and non-prime attributes can not depend on the part of PK. So, in the student-project example in 2NF, how if project_name and project_id forms a relation? Isn't it invalidating the concept of 2NF?

[@user-dz3ex7en7e]

8:36 please show the cat behind you

[@sauravtarun8495]

How many more videos will be there on this playlist?

[@Samiullah-vd6sm]

Total 25 lag baag aengay

[@aishwaryavishwanath3806]

You guys are amazing

[@AryanJC07]

Ek dam kadak❤

[@abhishekkeshri3974]

the cute cat behind you ...........😅😅😅😅

[@rajeshs1951]

Thanks bhaiya 🙏

[@RohitSingh-hc8yi]

It was quite well explained

[@SajanKumar-ec2us]

i have nt understand prime attribute and non prime attribute

[@sahilsingh5695]

17:56 CD->A ok CD->C ok.......CD->AC (AC whole another combination nahi hogya) ma dimag ma image nahi bna paa rha hu...if you can explain more about this.

[@sayandeepsoren361]

Nice Explanation

[@heromunfa9317]

Bahi dsa series continue kren plzz

[@ashutoshkumargiri3194]

Nice Explanation bhaia

[@RajNamdev_19]

Thanks

[@Devkumar-en7zu]

Sir plz clear one doubt that what is the meaning of sunset here bcz in non-trivial example how can we reach to the conclusion that it is a non trivial fd

[@ankushladani496]

Maja aa gaya bhaiya...

[@dainaetishaa5006]

Thank you again😊😊😊

[@yashwantptl7]

bohot hi badhiya

[@sumitchandola7126]

mera concentration toh peeche baithi billi(cat) pr jyaada hai 😂😂

[@Sham_Dravid_03]

😂😂😂😂

[@bhavikpatel5195]

57:32 why prime attribute can not find prime sttribute??????????????? ps:can anyone explain???

[@anshumanrout2739]

agar prime se prime dhundne lage to us prime ka kya wajut rahega ? wo bolega "apun ka koi ijjat nai hai , ham yahan hain sabko dhundne ke liye par koi hame hi dhund le raha hai"

[@bhavikpatel5195]

@@anshumanrout2739 shi hai👌

[@AryanSingh-rizz]

I have a confusion what is that white organism behind you and what is it's name 💖

[@sachinjha8042]

Nice explanation 👍

[@moment7206]

great learning exprience

[@mohammedsuhail8706]

At 40:00 How can a primary key value be null That's not allowed na

[@your_name96]

all prime attributes of primary key can't be null, in case of composite key, some(not all) can be NULL

[@gouravmandal6517]

sir piche kia puppy hai ya cat?

[@dhiman.shanky]

Amazing bro ❤️❤️❤️❤️👍👍❤️❤️

[@Aakashhoney278]

peeche ek white billa hai

[@motivationalmusic3721]

Understood

[@vaibhavbisht9649]

[@ibrahimsiddiqui7798]

Very cute cat

[@harshitsamdhani2426]

Thank you

[@theanshshah]

Is dsa done or will there be more classes

[@anmolkeshri2187]

Thank you🙏🙏🙏🙏

[@youtubekumar8590]

Thanku bhaiya

[@AryanSingh-rizz]

Bhaiya aapne cat ka naam to bataya hi nhi

[@rvislive_]

ye bulkul class 12 ka equivalence relation jasa hai

[@vivekgautam2300]

p_id kahan se aayi bcnf wale example m ??

[@varunbansal8865]

how many videos are left in this playlist?

[@RohitSingh-hc8yi]

thanks a lot

[@rupambanerjee7575]

Waiting for this

[@taison0072]

Bhaiya please relational database design pe questions karaiye , schema design

[@arjunvaddadi7170]

Can someone tell in simple words what is candidate key

[@sumitsakpal7085]

maine video puri dekhi

[@TarunKumar-cn6in]

thanks sir

[@yuvrajrana7043]

heloo how at 44:23 how is it 2 NF because first table primary key is (student id and project id) but student name is fully dependent on student id ,, therefore partial dependecy

[@saisidharth454]

Because ProjectId in the new table is the Foreign key and not the primary key. Hence Student_name only depends on Student_ID and hence is said to be fully dependent. And Product_ID is required to link the two tables else we won't be able to find the project_Name for a particular student which would break the given functional dependency. Hope it is clear now.

[@akshayamin]

@@saisidharth454 Is it possible to create one table consist of Student_ID and Student_Name // AND other // Student_ID,Project_ID and Project_Name??

[@UPESUBHADEEP]

id----department yeh toh trivial hoga na toh phir non trivial kiyu bolrahe hein kiyuki id seh department pata chal chaljayega

[@VIKAS-fm5un]

Isi ki jarurat jyada thi normalisation 1nf 2nf 3nf and bcnf parso mera dbms ka paper hai important topic hai ye eske aane ke chance bahut h

[@lakshaykumar7518]

Btw, the videos made in this series are placements specific 😊

[@fazerugbrug439]

superb

[@saurabhyadav8645]

what is a prime attribute?

[@ankushladani496]

CD -> AC KESE AAYA KOI EXPLAIN KAREGA?

[@Hope_for_life]

amazing

[@advitkothari7302]

thnx

[@priyanshpatel2078]

Hmmm intresting

[@RohitSingh-hc8yi]

maja aa gaya

[@KratosProton]

great

[@aniruddhadas1651]

Nice 👍

[@NeyongLimbu-l1f]

completed 31st july 2024

[@spiritualengineer]

39:11 how can a table have more than 1 primary key??

[@0xhans]

composite primary key, when multiple attributes are clubbed together to make a primary attribute

[@Atul_Agnihotri]

there is 2 other also 4NF and 5NF ??

[@adityakanwar2607]

wo ni puchenge bhai

[@kumarlakshya4407]

i think bhaiyya himself studied from KNOWLEDGE GATE

[@dailydestress6189]

39:20 How can we store null in a prime attribute ?

[@amanmusicality]

watch complete sql wali video bhai

[@lovedeepsingh1793]

agar composite primary key he to shyd ek null le sakte he