1 / 4

Keys

Keys. Primary Foreign Candidate Surogat Super. Differences. Primary keys: Identifies a single row (unique) Foreign: Identifies a single row in a referenced table. The nature of a key. Surogat : A self invented self genereted key Super

coen
Download Presentation

Keys

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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!

More Related