Alle boeken

Professioneel

Apps Over Coach Inloggen Begin met lezen

Quantitative Finance · Begrippenlijst

Wat is Relational model, primary key, foreign key?

Ook bekend als: relational model · primary key · foreign key

Definition 25.1 Research, Data and Risk Platforms · Hoofdstuk 25 — Databases and SQL

The relational model, proposed by Codd in 1970, stores data as relations — tables of rows with named, typed columns — manipulated by operations on whole relations (selection, projection, join), independently of how rows are stored. A primary key is a set of columns whose values identify one row; a foreign key is a set of columns whose values must appear as the primary key of a row in another table.

Lees in het hoofdstuk →