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
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.
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
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.
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..
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: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
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
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?
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.
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
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"
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.
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 UA-cam. Thanks
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.
yeh toh mene bhi nhi dekha, fir toh yeh example, BCNF nhi hoga, kyoki yeh 2NF hi nhi hai 🤔
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
Explained so clearly with examples❤, just got better idea in dbms which i wasn't when i learned it in clg1 year back
Waiting for next videos bhaiya, my placement season is going on , and i am mostly dependable on this series for 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.
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.
THANKS A LOT FOR THIS SERIES GUYS. REALLY HELPED. 🙏🙏
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.
thanks for this DBMS series video Sir and expecting the DP series to come with more videos soon...
56:42 yaha pe professor->subject also exists so the 3NF condition is violated??
well explained...i completely understood this normalisation concept...thank a lot brother.
16:00 pe B--> C is possible
+1
NO not possible
Thank you bhaiya for your efforts and your explanation is the BEST❤
Thank you for the lecture, it really helped me a lot. Wonderful work.
there is a white cat in his background 6:46....thank you sir for lecture
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.
55:00 sir in student prime attribute (id) , how it can detetmine 101 and 102
Thank you 😊
Bhaiya ek telegram channel ka discuss group bnado
Great Teaching Method Bhaiyya
Sab samaz mei agaya
Lakshay Sir is like God to me
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.
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.
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
BCNF is not clearly taught.
56:30 student table me s_id PK kaise ho skta hai because it should be unique and NOT NULL?
aap jaies teacher aur god student ke liye ek saman hote hai
love you CodeHelp - by Babbar ❤❤❤❤❤❤✔✔
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
Thank you for all the effort. It is highly appreciated
Day 11 - Present Sir❤
the cute cat behind you ...........😅😅😅😅
Thanks For Teaching DBMS ❤️
Sir,how to company decides package during the placement?
8:36 please show the cat behind you
Bahi dsa series continue kren plzz
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
Amazingly well explained . Thanks a lot Lakshay Bhaiya ..>
The way of explanation is very amazing
Thanks bhaiya 🙏
Ek dam kadak❤
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?
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.
You guys are amazing
Nice Explanation
Thanks
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
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👌
It was quite well explained
How many more videos will be there on this playlist?
Total 25 lag baag aengay
peeche ek white billa hai
Nice Explanation bhaia
maine video puri dekhi
bohot hi badhiya
mera concentration toh peeche baithi billi(cat) pr jyaada hai 😂😂
😂😂😂😂
great learning exprience
Very cute cat
Maja aa gaya bhaiya...
Thank you again😊😊😊
Understood
Nice explanation 👍
I have a confusion what is that white organism behind you and what is it's name 💖
Thank you
Bhaiya please relational database design pe questions karaiye , schema design
Thanku bhaiya
i have nt understand prime attribute and non prime attribute
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
Amazing bro ❤️❤️❤️❤️👍👍❤️❤️
thanks a lot
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 😊
ye bulkul class 12 ka equivalence relation jasa hai
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??
thanks sir
superb
Hmmm intresting
Waiting for this
Is dsa done or will there be more classes
Can someone tell in simple words what is candidate key
sir piche kia puppy hai ya cat?
great
how many videos are left in this playlist?
Nice 👍
maja aa gaya
i think bhaiyya himself studied from KNOWLEDGE GATE
what is a prime attribute?
p_id kahan se aayi bcnf wale example m ??
CD -> AC KESE AAYA KOI EXPLAIN KAREGA?
completed 31st july 2024
Bhaiya aapne cat ka naam to bataya hi nhi
39:11 how can a table have more than 1 primary key??
composite primary key, when multiple attributes are clubbed together to make a primary attribute
39:20 How can we store null in a prime attribute ?
watch complete sql wali video bhai
agar composite primary key he to shyd ek null le sakte he
id----department yeh toh trivial hoga na toh phir non trivial kiyu bolrahe hein kiyuki id seh department pata chal chaljayega
hehhe i love your dog!!
test2
there is 2 other also 4NF and 5NF ??
wo ni puchenge bhai