DBMS - Boyce-Codd Normal Form (BCNF)

preview_player
Показать описание
DBMS - Boyce-Codd Normal Form (BCNF)
Lecture By: Mr. Arnab Chakraborty, Tutorials Point India Private Limited
Рекомендации по теме
Комментарии
Автор

Use coupon "YOUTUBE12" to get ‘’FLAT 12%’’ OFF at Checkout.

TutorialsPoint_
Автор

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!

tkrishna
Автор

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

rishabhkumargupta
Автор

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

ashutoshanand
Автор

Sid, advisor->major. Is it possible?

krsumant
Автор

point 1 and point 5 for the table is basically same !

as
Автор

Here Isn't the given example is already in bcnf as it is satisfying 2nd condition
Because, STD major is a super key

Rupeshdevilcoolz
Автор

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.

endarsuprih
Автор

you don't know how to teach.. simply by reading you can't call it as teaching

ishaanms