सभी किताबें

पेशेवर

ऐप्स परिचय Coach लॉग इन पढ़ना शुरू करें

Quantitative Finance · शब्दावली

Relational model, primary key, foreign key क्या है?

अन्य नाम: relational model · primary key · foreign key

Definition 25.1 Research, Data and Risk Platforms · अध्याय 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.

अध्याय में पढ़ें →