3.13 Finding Number Of Candidate Key Examples

  Рет қаралды 169,620

KnowledgeGATE by Sanchit Sir

KnowledgeGATE by Sanchit Sir

Күн бұрын

Пікірлер: 75
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg Жыл бұрын
For complete DBMS, check out this video: kzbin.info/www/bejne/j4PRm3qbhsemfrM
@inclinedscorpio
@inclinedscorpio 5 жыл бұрын
*You got a message !* - Mother Earth Needs more people like you in order to push students like me ahead of the rank crowd.
@jaydoshi_
@jaydoshi_ 6 жыл бұрын
Sir at time 11:33 CDH will also be there to be checked!!.. Tho it is not a candidate key.
@pavansingh8089
@pavansingh8089 6 жыл бұрын
Yes you are right but it's just a silly mistake.
@sarojsharma7526
@sarojsharma7526 5 жыл бұрын
Yes I also noticed
@rachanachaudhari7414
@rachanachaudhari7414 5 жыл бұрын
CGH also
@drazerking9012
@drazerking9012 5 жыл бұрын
@@rachanachaudhari7414 No because 'D' is essential.
@tumtum6910
@tumtum6910 4 жыл бұрын
@@drazerking9012 but D is not a candidate key...
@PANKAJKUMAR-fe8zn
@PANKAJKUMAR-fe8zn 6 жыл бұрын
kamal ka concept clear huwa sir.....great effort on video sir...
@aditipandey1995
@aditipandey1995 5 жыл бұрын
Thank u so much sir for all the videos.. Ur way to teaching is very nice... I have watched every video for ur's from 3.1 to 3.13 n now i am able to solve questions... Thanks alot..
@rudrachoudhury9175
@rudrachoudhury9175 6 жыл бұрын
Make a video on Relational algebra,ER-Diagram
@MOFOfromearth
@MOFOfromearth 6 жыл бұрын
Yes, please! This would help a lot!
@Harendrasingh-op3lv
@Harendrasingh-op3lv 6 жыл бұрын
u can prefer GateBook letures by Kiran sir
@shayakfarheen5826
@shayakfarheen5826 6 жыл бұрын
sir.…. your teaching style is fab..
@CSESecB
@CSESecB 5 жыл бұрын
sir in 4th question indiviual E and F are also candiate keys right?
@dattatreyapujar4068
@dattatreyapujar4068 6 жыл бұрын
Very well !! My doubt got clear.
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 2 жыл бұрын
🔥Complete DBMS by Sanchit Sir: tiny.cc/DBMS_Sanchitsir_kg 🔥🔥All Computer Science Subjects by Sanchit Sir: tiny.cc/CSbundle_dbms_kg
@deepanshusingh7922
@deepanshusingh7922 5 жыл бұрын
Really hard work 👍👍 Thank you so much sir
@SorabhMirchonia
@SorabhMirchonia 5 жыл бұрын
You are the best SIR !
@ashurawat6752
@ashurawat6752 6 жыл бұрын
Sir plz locking protocols pr bna do video
@gappaofgolluugupta5464
@gappaofgolluugupta5464 6 жыл бұрын
Sir I really love you you are osm Main sch kaha rha hu hu sir apka kitna lecture Ek sath dakh lu Pr bor hi nhi hota or clg main to so jata hu
@deepakgodara6436
@deepakgodara6436 6 жыл бұрын
Sir iss particular topic pr bohot focus kr rhe ho aap 😃😃✌️✌️
@supamdeepbains5172
@supamdeepbains5172 4 жыл бұрын
HANDS DOWN BEST CHANNEL
@abirpaul9027
@abirpaul9027 3 жыл бұрын
Thik hai sir!!!
@Skevalk
@Skevalk 6 жыл бұрын
Sir plz upload next videos of group theory...
@saddamahmad2310
@saddamahmad2310 6 жыл бұрын
Thank You Very much sir for this video
@ai-track-321-go
@ai-track-321-go 6 жыл бұрын
nice one!
@mohitbhambri3433
@mohitbhambri3433 6 жыл бұрын
Sir plzz make video lectures on E R DIAGRAM....
@ashishn.c.7913
@ashishn.c.7913 5 жыл бұрын
best teacher
@askariaziz4163
@askariaziz4163 4 жыл бұрын
well explained
@kanubhav26
@kanubhav26 6 жыл бұрын
in que. 6 one possible combination could be chd although it will not find R
@Harendrasingh-op3lv
@Harendrasingh-op3lv 6 жыл бұрын
yeah
@Harendrasingh-op3lv
@Harendrasingh-op3lv 6 жыл бұрын
@@sn-oc9iw why DE is essential ?. Only D is essential.
@Harendrasingh-op3lv
@Harendrasingh-op3lv 6 жыл бұрын
@@sn-oc9iw as E is identify by F.
@sn-oc9iw
@sn-oc9iw 6 жыл бұрын
@@Harendrasingh-op3lv yup i saw wrongly
@Harendrasingh-op3lv
@Harendrasingh-op3lv 6 жыл бұрын
@@sn-oc9iw 😊
@singhscribe7450
@singhscribe7450 2 жыл бұрын
In ques no 5 @8:52 AD and AC cannot be the Candidate keys????????
@anubhavnegi7428
@anubhavnegi7428 6 жыл бұрын
Good questions.
@dipakraut6058
@dipakraut6058 4 жыл бұрын
Thank You So much Sir😁
@kbhargavi4400
@kbhargavi4400 5 жыл бұрын
tq so much for ur valuable videos sir.Hope u support us in the same way.
@anushyasundarrajan1198
@anushyasundarrajan1198 4 жыл бұрын
show examples based on tables to get a much better understanding sir
@AshishDubey-md2kv
@AshishDubey-md2kv 6 жыл бұрын
Sir I request you to first finish the dbms in english course as you have not covored the locking protocols.
@gorakhkumargupta491
@gorakhkumargupta491 2 жыл бұрын
Massive video
@salonipande6190
@salonipande6190 6 жыл бұрын
Thank u so much sir
@Livewithsush94
@Livewithsush94 5 жыл бұрын
you are the best
@sunandasingh9479
@sunandasingh9479 6 жыл бұрын
Sir plz discrete mathematics ...ka topic counting ...permutation, combination, pigeonhole principle, Element of probability. Is topic pr bana dijiye.......
@ruchikansakar765
@ruchikansakar765 5 жыл бұрын
In question 2 A and B also don't have any incoming edge.
@SACHINKUMAR-kb3db
@SACHINKUMAR-kb3db 5 жыл бұрын
Ruchi Kansakar yes dear😅😅.. u r very brilliant😅😅😅
@adityalodhi4023
@adityalodhi4023 6 жыл бұрын
Sir if we are not given by FD's .we have only a relation which have 5 attributes and ABC is the candidate key of it .then how can be find no of possible super key.plz make a video on it.Thank you
@malikislam4643
@malikislam4643 2 жыл бұрын
i hv dout on how to make combinations in this lecture
@paras_sachan
@paras_sachan 5 жыл бұрын
i think .... if we have to find without incoming element then we not need to draw anything...we can see on left side ...if any element is not present then we can easily find the element. Am I right
@muhammadiqbalbazmi9275
@muhammadiqbalbazmi9275 6 жыл бұрын
keep being awesome
@deepikasharma1370
@deepikasharma1370 6 жыл бұрын
sir how we ensure about incoming edge to any attribute...it is not getting sir
@SACHINKUMAR-kb3db
@SACHINKUMAR-kb3db 5 жыл бұрын
Deepika Sharma just check previous video.. you will get the answer
@SACHINKUMAR-kb3db
@SACHINKUMAR-kb3db 5 жыл бұрын
Deepika Sharma dear.. aero k right side me jo v letter h wha pr incoming edge rahega..
@sid_1007
@sid_1007 2 жыл бұрын
Sir in q6, a,b are also ck
@mannusharma321
@mannusharma321 6 жыл бұрын
Sir v nyc video but in sixth question DE is not candidate key .
@aditikumari3358
@aditikumari3358 6 жыл бұрын
plz upload more video on candidate key
@michealoven9826
@michealoven9826 6 жыл бұрын
Where is types of Relationship video?
@anitasaini9146
@anitasaini9146 5 жыл бұрын
👍☺️
@SACHINKUMAR-kb3db
@SACHINKUMAR-kb3db 5 жыл бұрын
Anita Saini i think you are from Bengal😇😅😅
@triptibhardwaj9454
@triptibhardwaj9454 6 жыл бұрын
👍👍
@yogendrasinghchauhan8397
@yogendrasinghchauhan8397 6 жыл бұрын
gr8
@pnjunction211
@pnjunction211 2 жыл бұрын
Sir I think question number 2's answer is not right. Please check it out
@jimitmehta1962
@jimitmehta1962 9 ай бұрын
@KNOWLEDGEGATE_kg sir can you give me answer of this question Given RMED(Trade-Name, Generic-Name, Manufacturer, Batch-No, Stock, MRP, Tax-Rate), and following FDs, Compute Key a. Trade-Name → Generic-Name b. Trade-Name → Manufacturer c. Batch-No → Trade-Name d. Batch-No → Stock e. Batch-No → MRP f. Generic-Name → Tax-Rate my answer is coming batch no only is it correct or wrong
@basitmaqbool2416
@basitmaqbool2416 3 жыл бұрын
Sir, I wanna Kiss you, the way you teach... Simple and Easy... Thanks a lot sir... Love from Kashmir
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 3 жыл бұрын
Thank you so much😀Visit tiny.cc/yt_kgwebsite for more courses and content 👍Connect with us on our Social Media platforms for updates linktr.ee/ConnectWithUs_Knowledgegate😍
@Pankajkumar-dy9ef
@Pankajkumar-dy9ef 6 жыл бұрын
superhero
@manojrajput6481
@manojrajput6481 4 жыл бұрын
I think in 4th Question, AC should also be Candidate key.
@nikitasinha8181
@nikitasinha8181 4 жыл бұрын
Thank u so much sir 🙏
@bhavnagoswami1273
@bhavnagoswami1273 3 жыл бұрын
Thanks a lot sir
@KNOWLEDGEGATE_kg
@KNOWLEDGEGATE_kg 3 жыл бұрын
Most welcome Bhavna.. Keep learning and supporting !! Do visit our website www.knowledgegate.in for more courses and contents.
4.1 Insertion Deletion and Updation Anomalies, Data Redundancy Inconsistency in DBMS
14:52
KnowledgeGATE by Sanchit Sir
Рет қаралды 345 М.
3.12 Finding Number Of Candidate Key
24:42
KnowledgeGATE by Sanchit Sir
Рет қаралды 308 М.
路飞做的坏事被拆穿了 #路飞#海贼王
00:41
路飞与唐舞桐
Рет қаралды 26 МЛН
黑天使只对C罗有感觉#short #angel #clown
00:39
Super Beauty team
Рет қаралды 34 МЛН
4.2 Basic Concept of Normalization
13:34
KnowledgeGATE by Sanchit Sir
Рет қаралды 742 М.
Finding Number of CANDIDATE KEY  | DBMS
18:49
KnowledgeGATE by Sanchit Sir
Рет қаралды 305 М.
4.10 Decomposition into 3NF Third Normal Form
21:46
KnowledgeGATE by Sanchit Sir
Рет қаралды 386 М.
रेस्टोरेंट किया सील - IAS Deepak Rawat
10:52
Deepak Rawat IAS
Рет қаралды 4,8 МЛН
3.4 Armstrong's Axioms and Inference Rules in Functional Dependency
20:59
KnowledgeGATE by Sanchit Sir
Рет қаралды 377 М.
8.11 Conflict Serializable Schedule With Precedence Graph
18:25
KnowledgeGATE by Sanchit Sir
Рет қаралды 279 М.
How to compute canonical cover
10:14
10 Minutes Lectures in Computer Science
Рет қаралды 14 М.