Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
difference between super, candidate,alternate keys
This is a discussion on difference between super, candidate,alternate keys within the Database General forums, part of the Databases category; Hi, can someone tell me the difference between Super, Altrenate, and Candidate keys? Thanks...
|
|||||||
08-12-2008
|
|||
|
|||
|
difference between super, candidate,alternate keys
Hi,
can someone tell me the difference between Super, Altrenate, and Candidate keys? Thanks 
|
| The Following User Says Thank You to vaishali1763 For This Useful Post: | ||
| Sponsored Links |
|
08-14-2008
|
|||
|
|||
|
Re: difference between super, candidate,alternate keys
If u add other attributes of a table to the primary key then that combination would be a super key.
Any attribute or a set of attributes which can uniquely identify a tuple or row in a table is called candidate key.There may be more than one candidate key in a table but among them we choose one to be primary key. Any key other than primary key is known as alternate key.
|
 |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Candidate key | babi_geek | Oracle | 5 | 10-06-2008 03:58 AM |
| AJAX Made Easy - Effective Use of Alternate Style Sheets in Ajax | Lokesh M | AJAX & XML | 0 | 08-01-2008 11:10 PM |
| Capturing Alternate data stream | klez79 | Testing Issues | 0 | 12-05-2007 09:04 PM |
| Reservation in HAL for PH candidate | Geek_Guest | QTP | 0 | 10-12-2007 03:45 PM |
| Super Wifi | suji | Geeks Lounge | 1 | 05-28-2006 11:31 AM |
All times are GMT -4. The time now is 12:24 PM.
