Tous les livres

Professionnel

Applis À propos Coach Connexion Commencer la lecture

Quantitative Finance · Glossaire

Qu'est-ce que « Relational model, primary key, foreign key » ?

Aussi appelé : relational model · primary key · foreign key

Definition 25.1 Research, Data and Risk Platforms · Chapitre 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.

Lire dans le chapitre →