Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
Keys PowerPoint Presentation

Keys

180 Vues Download Presentation
Télécharger la présentation

Keys

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Keys Primary Foreign Candidate Surogat Super

  2. Differences Primary keys: Identifies a single row (unique) Foreign: Identifies a single row in a referenced table.

  3. The nature of a key • Surogat: A self invented self genereted key • Super A set of fields that uniquely describe a row • Candidate: A minimal superkey – it cannot be broken into smaller parts

  4. Wiki’s definition • In relational database design, a unique key or primary key is a candidate key to uniquely identify each row in a table. A unique key or primary key comprises a single column or set of columns. No two distinct rows in a table can have the same value (or combination of values) in those columns. Depending on its design, a table may have arbitrarily many unique keys but at most one primary key. WRONG!