Prime and Non-prime Attribute | Database Management System

preview_player
Показать описание

IMPORTANT LINKS:
Both of the above mentioned platforms are COMPLETELY FREE, so feel free to Explore, Learn, Practice & Share!

Our Social Media Links:

Last but not the least, SUBSCRIBE our YouTube channel to stay updated about the regularly uploaded new videos.
Рекомендации по теме
Комментарии
Автор

one of my favorite channels on youtube for IT self-study.
breaking things apart on short videos makes e-learning more efficient
Thanks for spreading the knowledge 

SuperDvco
Автор

Thank you sir you! explain better than my professor.

jamescontini
Автор

Thanks for this video! I've been confused with these concepts as of late but this video has made it much clearer!

dnangel
Автор

It was a very crisp and perfectly explained! Thanks a lot

adithyasivasankar
Автор

Very much grateful for this nice explanation.

mdmushfiqulislam
Автор

Hi TECHTUD! Brilliant explanation but i am confused. Why is A a NON prime attribute. Closer of CEA will get you all attributes. Doesnt this make CEA a candidate key? If thats the case shouldnt A also be a prime attribute?

damudread
Автор

thank you sir . very clear explanation

freddymansour
Автор

R(MNOPQRST), F=(Q-->RST, MN-->PQRST, O-->PQ, P-->M) Can you identify the prime and non prime attributes from the given functional dependencies?

sukanyapechetti
Автор

Sir...
What about non prime attributes in such case..
We have a relation (A B C D) and from that relation, let us consider to that we got C.K as AD, BD, CD and now prime attributes are ABCD ..
As of this condition what kind attribute we will take in non prime attributes...
I m just confused with those functional dependency and CK...
Please sir could explain us in one fresh I would grateful and I m sure that it will help to us like me ..

lazycrazy
Автор

Thanks alot brother !!! It helps me alot ...

rs_pawankumar
Автор

You said that there may be more than one candid key, then in that case others attributes that you said as non-prime also become prime attributes if wwe consider other candid key .Please help me, Am i wrong???

Mohith
Автор

what if there is an attribute from a ck and non prime att.. what it called..

tarakram
Автор

How to pronounce the word "determine":

ianfitchett