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.
@@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
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
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
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 !!!!!
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.
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.
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
56:30 I think the resultant decomposed table of prof_id, prof, subject violates 3NF so we again can decompose it into two tables one containing prof_id, prof and other one as prof_id, subject with prof_id being the primary key here.
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.
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
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..
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.
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?
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 ?
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
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
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
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
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.
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"
Hello sir I loved your video.... I just wanna know that which software application are using... that doodling. Which you use to write write using stylus.... ❤️ from mymbai
47:51 pe yaha ye B->C (c prime attribute kaise ho ja raha hai?????)
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.
Thanks Akash for the clarification :)
It was a miss!
@@lakshaykumar7518 Thank you Bhaiya for Considering and pinning it to the top.
@@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
Can anyone suggest a video on how to find normal form
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
Thanks brah
background mai cat ka timestamps bhi dawdle
all those topics were like so tough during cllg days but u made it so much easier thank u so much.
true that
Examples helped a lot, I did not find a better explanation than this on TH-cam. Thanks
Explained so clearly with examples❤, just got better idea in dbms which i wasn't when i learned it in clg1 year back
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
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 !!!!!
Waiting for next videos bhaiya, my placement season is going on , and i am mostly dependable on this series for dbms .. !!
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.
yeh toh mene bhi nhi dekha, fir toh yeh example, BCNF nhi hoga, kyoki yeh 2NF hi nhi hai 🤔
16:00 pe B--> C is possible
+1
NO not possible
THANKS A LOT FOR THIS SERIES GUYS. REALLY HELPED. 🙏🙏
Great Teaching Method Bhaiyya
Sab samaz mei agaya
thanks for this DBMS series video Sir and expecting the DP series to come with more videos soon...
well explained...i completely understood this normalisation concept...thank a lot brother.
Wonderful explanation! Kudos 👏👏
aap jaies teacher aur god student ke liye ek saman hote hai
love you CodeHelp - by Babbar ❤❤❤❤❤❤✔✔
Lakshay Sir is like God to me
Thank you for the lecture, it really helped me a lot. Wonderful work.
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.
+1
you are going vice versa of the Reflexive property,it need not be true.
superb explanation!!
the cute cat behind you ...........😅😅😅😅
Very helpful video bhai❤️
Thank you bhaiya for your efforts and your explanation is the BEST❤
there is a white cat in his background 6:46....thank you sir for lecture
56:45 there we can get the subject_name from professor meaning nonprime ->nonprime, isn't that a redundancy
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.
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
Thanks For Teaching DBMS ❤️
56:30 I think the resultant decomposed table of prof_id, prof, subject violates 3NF so we again can decompose it into two tables one containing prof_id, prof and other one as prof_id, subject with prof_id being the primary key here.
BCNF is not clearly taught.
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??
yeah, i also thought that, you are right
I think Professor id shouldn't appear in the tables and Professor should become P.K in that table.
@@tusharverma4202 then partial depencency b/w p_id and subject would exist
also using professor you can find pid which not full fill bcnf
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.
Day 11 - Present Sir❤
Ek dam kadak❤
Thank you 😊
Thank you for all the effort. It is highly appreciated
Bhaiya ek telegram channel ka discuss group bnado
Amazingly well explained . Thanks a lot Lakshay Bhaiya ..>
bohot hi badhiya
The way of explanation is very amazing
Thanku sir ❤
at 56:44 if stud_id is primary key but it is not unique in that table as you have written
101 1
101 2
Nice Explanation bhaia
At 41:37 B kaise determine kri hai c ko in 2NF realtion 2. B to null hai
A --> C Hona chaiye na .
we make B a primary key in another table, then we can't set it to null.
Nice Explanation
56:42 yaha pe professor->subject also exists so the 3NF condition is violated??
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
55:00 sir in student prime attribute (id) , how it can detetmine 101 and 102
8:36 please show the cat behind you
Bahi dsa series continue kren plzz
It was quite well explained
Maja aa gaya bhaiya...
Thanks bhaiya 🙏
great learning exprience
maine video puri dekhi
Sir,how to company decides package during the placement?
You guys are amazing
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..
ya that's a clear mistake , ek bachha do teacher se kaise padh sakta hai .
1NF bhi nhi ye table.
Thanku bhaiya
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.
56:30 student table me s_id PK kaise ho skta hai because it should be unique and NOT NULL?
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?
Very cute cat
Nice explanation 👍
How many more videos will be there on this playlist?
Total 25 lag baag aengay
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
Btw, the videos made in this series are placements specific 😊
Thank you again😊😊😊
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 ?
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
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
Is dsa done or will there be more classes
thanks a lot
i think bhaiyya himself studied from KNOWLEDGE GATE
Hmmm intresting
Amazing bro ❤️❤️❤️❤️👍👍❤️❤️
superb
how many videos are left in this playlist?
maja aa gaya
I have a confusion what is that white organism behind you and what is it's name 💖
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
Thank you🙏🙏🙏🙏
thanks sir
Waiting for this
Bhaiya please relational database design pe questions karaiye , schema design
in last student professor table student id me 101 2 times aa raha he to voh atomic value kaise hui its not 1NF then how it is 3NF
Understood
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
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.
@@saisidharth454 Is it possible to create one table consist of Student_ID and Student_Name // AND other // Student_ID,Project_ID and Project_Name??
At 40:00
How can a primary key value be null
That's not allowed na
all prime attributes of primary key can't be null, in case of composite key, some(not all) can be NULL
Nice 👍
sir piche kia puppy hai ya cat?
great
p_id kahan se aayi bcnf wale example m ??
i have nt understand prime attribute and non prime attribute
peeche ek white billa hai
thnx
ye bulkul class 12 ka equivalence relation jasa hai
hehhe i love your dog!!
57:32 why prime attribute can not find prime sttribute???????????????
ps:can anyone explain???
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"
@@anshumanrout2739 shi hai👌
mera concentration toh peeche baithi billi(cat) pr jyaada hai 😂😂
😂😂😂😂
id----department yeh toh trivial hoga na toh phir non trivial kiyu bolrahe hein kiyuki id seh department pata chal chaljayega
Hello sir I loved your video....
I just wanna know that which software application are using... that doodling. Which you use to write write using stylus....
❤️ from mymbai
bro its MYsql workbench
CD -> AC KESE AAYA KOI EXPLAIN KAREGA?
Bhaiya aapne cat ka naam to bataya hi nhi
there is 2 other also 4NF and 5NF ??
wo ni puchenge bhai