Alternate key

Alternate key

"You may have meant the Alt key on the keyboard."

An alternate key (or secondary key) is any candidate key which is not selected to be the primary key (PK).

For example, a relational database with a table "employee" could have attributes like "employee_id", "bank_acct_no", and so on. In this case, both "employee_id" and "bank_acct_no" serve as unique identifiers for a given employee, and could thus arguably be used for a primary key. Hence, both of them are called "candidate keys". If, for example, "bank_acct_no" was chosen as the primary key, "employee_id" would become the alternate key.


Wikimedia Foundation. 2010.

Игры ⚽ Нужен реферат?

Look at other dictionaries:

  • Alternate reality game — This article is about the genre. For the specific 1980s series, see Alternate Reality (computer game). An alternate reality game (ARG) is an interactive narrative that uses the real world as a platform, often involving multiple media and game… …   Wikipedia

  • Alternate character — This article is about the use of alternative characters in MUDs and MMORPGs. For the use of multiple characters in role playing games, see Troupe system. For the ALT key on computer keyboards, see Alt key. An alternate character, often referred… …   Wikipedia

  • Alternate ending — For the Fightstar album, see Alternate EndingsAlternate ending is a term used (usually in movies) to describe the ending of a story that was planned or debated but ultimately unused in favor of the actual ending. Generally, alternate endings are… …   Wikipedia

  • Key Sequenced Data Set — A Key Sequenced Data Set (KSDS) is a type of data set used by the IBM VSAM computer data storage system. Each record in a KSDS data file is embedded with a unique key. A KSDS consists of two parts, the data component and a separate index file… …   Wikipedia

  • Alternate versions of Captain America — In addition to his mainstream incarnations, Captain America has also been depicted in other fictional universes.Modern continuity*Steve Rogers The scrawny Army reject was given the Super Soldier serum, becoming the first and only complete success …   Wikipedia

  • Key of Heart / Dotch — Infobox Single Name = KEY OF HEART |200px Artist = BoA from Album = Made in Twenty (20) Released = JPN: August 9, 2006 KOR: August 21, 2006 Format = CD+DVD Recorded = 2006 Genre = Pop Length = Label = Avex Trax Producer = ? Reviews = Last single …   Wikipedia

  • Key Largo (film) — Infobox Film name =Key Largo caption = director =John Huston producer =Jerry Wald writer =Maxwell Anderson (play), Richard Brooks, John Huston starring =Humphrey Bogart Edward G. Robinson Lauren Bacall Lionel Barrymore Claire Trevor Marc Lawrence …   Wikipedia

  • Alternate versions of Apocalypse — In addition to his mainstream incarnation, Apocalypse has had been depicted in other fictional universes.Age of ApocalypseIn the alternate timeline (Earth 295), Apocalypse arose ten years before he was awoken by Cable; having witnessed the… …   Wikipedia

  • Alternate — ● ►en /al teur naiy t/ np. ►KEY touche de commutation classique du clavier, sur un PC. Abrégé souvent en Alt …   Dictionnaire d'informatique francophone

  • Unique key — In relational database design, a unique key can uniquely identify each row in a table, and is closely related to the Superkey concept. A unique key comprises a single column or a set of columns. No two distinct rows in a table can have the same… …   Wikipedia

Share the article and excerpts

Direct link
Do a right-click on the link above
and select “Copy Link”