DBMS - Keys Foreign, Partial, Secondary

[@TutorialsPoint_]

To Get Certification, Click Here: bitly.ws/PXXy Use coupon "KZbin12" to get ‘’FLAT 12%’’ OFF at Checkout.

[@bidishasengupta3434]

Thank you, sir. First time understood Foreign Key so well.

[@shadmanahmed3666]

thanks l like your teaching

[@rupanag]

Do you have any video which explains conceptual model? I have a question. In conceptual model, can two entities be associated with both direct and indirect relationship? e.g. engineer inspects item. This inspection generates inspection report. So entity 'engineer ' can have a relationship 'inspects' with entity 'item'. Also entity 'engineer 'can have a relation 'conducts' with entity 'item inspection'. Entity 'item' will have a relationship 'undergoes' with entity 'item inspection'. Is it valid?

[@dasaridharani6529]

is alternate key and secondary key is both are same?

[@shreyasrajanna7361]

Thanks for teaching

[@agaquliyev4479]

Thanks heaps dear teacher

[@PraveenKumar-qj3rm]

Sir is it possible to have more than one primary key in a record?

[@sudarshanlahoti3856]

No

[@karannakra9426]

no

[@Saed7630]

Excellent!

[@the_anuragsrivastava]

nicely explained...thanks sir

[@deepikasinha4779]

very nice information

[@sk.nadimislam5459]

Sir, what is actually the difference between 'Foreign key' & 'Partial key'?

[@awalktoinfinity665]

Exactly, same question @tutorialspoint(India)pvt.ltd.

[@dr.jaideepm738]

Foreign key is used to relate 2 tables an u uniquely identify a tuple. However partial key cannot uniquely identify a tuple and will give all its related information