Semua buku

Profesional

Aplikasi Tentang Pelatih Masuk Mulai membaca

Quantitative Finance · Glosarium

Apa itu Relational model, primary key, foreign key?

Dikenal juga sebagai: relational model · primary key · foreign key

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

Baca dalam konteks →