For about a month, i have watched different videos on BCNF but i don't have a solid understanding of it. This is just so perfect. Thanks for using a very good scenario to explain this.❤
wrong table splitting though, for example, if a student with SID: 123, take advisor of Faculty-1 and Faculty-4, the student will take the Physics twice. This situation is impossible before splitting.
The splitting table should be: Table 1: (SID(PK),Major(PK), Id_Advisor(FK)), Table 2: (id_Advisor(PK), Advisor, Major), or the simple one: Table1: (SID(PK),Major(PK), Advisor(FK)), Table2: (Advisor(PK), Major). Yes there are 2 Major in two tables, it is because the dependency is very unique before splitting as one of the primary key (major) that depends on a non primary key (Advisor)
Sir here I have a doubt for being a relation in BCNF each and every determinant should be either candidate key or super key but here advisor is a non prime attribute which determines major but advisor is not a candidate key please explain me ???
After forming bcnf, advisor has itself become a candidate key, see that it is underlined where it is present within brackets. Based on this fact the last two tables are made
Yes . it's possible. Because an advisor can teach only one subject. So if you get the teacher's name u can say which subject he/she teaches. But the opposite is not possible because a major can be taught be more than one teacher. :)
Still, wrong table splitting though, for example, if a student with SID: 123, take advisor of Faculty-1 and Faculty-4, the student will take the Physics twice. This situation is impossible before splitting.
To Get Certification, Click Here: bitly.ws/PXXy
Use coupon "TH-cam12" to get ‘’FLAT 12%’’ OFF at Checkout.
For about a month, i have watched different videos on BCNF but i don't have a solid understanding of it. This is just so perfect.
Thanks for using a very good scenario to explain this.❤
Well explained! I was in a confusion on how BCNF would make a difference from 3 NF. This presentation is a great reference for it!
wrong table splitting though, for example, if a student with SID: 123, take advisor of Faculty-1 and Faculty-4, the student will take the Physics twice. This situation is impossible before splitting.
The splitting table should be: Table 1: (SID(PK),Major(PK), Id_Advisor(FK)), Table 2: (id_Advisor(PK), Advisor, Major), or the simple one: Table1: (SID(PK),Major(PK), Advisor(FK)), Table2: (Advisor(PK), Major). Yes there are 2 Major in two tables, it is because the dependency is very unique before splitting as one of the primary key (major) that depends on a non primary key (Advisor)
Thanks a lot! This really helps.
Sir here I have a doubt for being a relation in BCNF each and every determinant should be either candidate key or super key but here advisor is a non prime attribute which determines major but advisor is not a candidate key please explain me ???
After forming bcnf, advisor has itself become a candidate key, see that it is underlined where it is present within brackets. Based on this fact the last two tables are made
why can we not take major --> advisor as FD ? How does you identify FD in given table ? i
face so many problem for identifying FD...
That is not a FD because a major is taught by more than one advisor.So by using major we cannot determine the faculty.
Thank you Sir, was very helpful
Nice explanation
Super sir.well explained
Thank you, very helpful!
Sid,advisor->major. Is it possible?
Yes . it's possible. Because an advisor can teach only one subject. So if you get the teacher's name u can say which subject he/she teaches. But the opposite is not possible because a major can be taught be more than one teacher. :)
Nice sir..
Awesome!
point 1 and point 5 for the table is basically same !
Was very helpful thanx
Here Isn't the given example is already in bcnf as it is satisfying 2nd condition
Because, STD major is a super key
Well explained
Still, wrong table splitting though, for example, if a student with SID: 123, take advisor of Faculty-1 and Faculty-4, the student will take the Physics twice. This situation is impossible before splitting.
what if the student wants to study extra?
No bro ...it's correct only check once
you don't know how to teach.. simply by reading you can't call it as teaching
absolute chub
Subject Phylix???! Lmao !!!!