Candidate, Primary, Alternate, Super and Composite key types in DBMS (SQL) My Blog: 🤍sqlwithmanoj.com/2014/09/15/db-basics-what-are-candidate-primary-composite-super-keys-and-difference-between-them/ "SQL Server Basics" series: 🤍🤍youtube.com/playlist?list=PLU9JMEzjCv14f3cWDhubPaddxRvx1reKR #SQLwithManoj #DatabaseBasics #SQLBasics #SQLServer #MySQL #Oracle #PostrgeSQL SQL blog: 🤍sqlwithmanoj.com/ LinkedIn: 🤍🤍linkedin.com/in/manub22/ Facebook: 🤍🤍facebook.com/sqlwithmanoj Telegram: 🤍t.me/sqlwithmanoj
Here is a good and short description of Primary and Foreign Keys
QxbbonscTkI QxbbonscTkI
Very nicely explained . thank u sir
Thanx a lot!
Great explanation!!!!
Nobody refers to it as "Date of Joining". It's almost always "Hire Date".
Thanks Buddy!!!... clear description!
Thanku Sir Ji
<iframe width="560" height="315" src=" youtube.com/embed/dzRzGGIezVw youtube.com/embed/dzRzGGIezVw " frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>
Thank you soooooo muchhhhhh
You're better than my Professor
Thanks alot
finally keys got cleared....thanks.
Awesome video.
Hi thanks a lot for this video. I want to mention that there is a typo on the composite key, it should be "if a table don't have..."
Nice explanations
Whats the difference between super key and composite key then ?
......yes....you are great person.....unlike some tutors whose tutorials are in pure
hindi
Thank you for this video. A more common composite key scenario is where one has dated material, for example in a payroll system, you could have multiple rows for the same employee (paid a salary over many months) but by adding payroll date to the employee ID you would have a unique composite key. Another natural scenario would be an order detail table, where you might combine an order ID plus an item ID to create a unique composite key for an order which includes many items.
Finally found the to the best explanation about keys concept. Thanks