Logo
Unionpedia
Communication
Get it on Google Play
New! Download Unionpedia on your Android™ device!
Free
Faster access than browser!
 

Primary key

Index Primary key

In the relational model of databases, a primary key is a specific choice of a minimal set of attributes (columns) that uniquely specify a tuple (row) in a relation (table). [1]

18 relations: Active record pattern, Candidate key, Column (database), Database, Due diligence, National identification number, Natural key, Object-relational mapping, Relation (database), Relational database management system, Relational model, Row (database), SQL, SQL:2003, Superkey, Surrogate key, Table (database), Unique key.

Active record pattern

In software engineering, the active record pattern is an architectural pattern found in software that stores in-memory object data in relational databases.

New!!: Primary key and Active record pattern · See more »

Candidate key

In the relational model of databases, a candidate key of a relation is a minimal superkey for that relation; that is, a set of attributes such that.

New!!: Primary key and Candidate key · See more »

Column (database)

In a relational database, a column is a set of data values of a particular simple type, one value for each row of the database.

New!!: Primary key and Column (database) · See more »

Database

A database is an organized collection of data, stored and accessed electronically.

New!!: Primary key and Database · See more »

Due diligence

Due diligence is an investigation of a business or person prior to signing a contract, or an act with a certain standard of care.

New!!: Primary key and Due diligence · See more »

National identification number

A national identification number, national identity number, or national insurance number is used by the governments of many countries as a means of tracking their citizens, permanent residents, and temporary residents for the purposes of work, taxation, government benefits, health care, and other governmentally-related functions.

New!!: Primary key and National identification number · See more »

Natural key

A natural key (also known as business key) is a type of unique key, found in relational model database design, that is formed of attributes that already exist in the real world.

New!!: Primary key and Natural key · See more »

Object-relational mapping

Object-relational mapping (ORM, O/RM, and O/R mapping tool) in computer science is a programming technique for converting data between incompatible type systems using object-oriented programming languages.

New!!: Primary key and Object-relational mapping · See more »

Relation (database)

In relational database theory, a relation, as originally defined by E. F. Codd, is a set of tuples (d1, d2,..., dn), where each element dj is a member of Dj, a data domain.

New!!: Primary key and Relation (database) · See more »

Relational database management system

A relational database management system (RDBMS) is a database management system (DBMS) based on the relational model invented by Edgar F. Codd at IBM's San Jose Research Laboratory.

New!!: Primary key and Relational database management system · See more »

Relational model

The relational model (RM) for database management is an approach to managing data using a structure and language consistent with first-order predicate logic, first described in 1969 by Edgar F. Codd, where all data is represented in terms of tuples, grouped into relations.

New!!: Primary key and Relational model · See more »

Row (database)

In the context of a relational database, a row—also called a tuple—represents a single, implicitly structured data item in a table.

New!!: Primary key and Row (database) · See more »

SQL

SQL (S-Q-L, "sequel"; Structured Query Language) is a domain-specific language used in programming and designed for managing data held in a relational database management system (RDBMS), or for stream processing in a relational data stream management system (RDSMS).

New!!: Primary key and SQL · See more »

SQL:2003

SQL:2003 is the fourth revision of the SQL database query language.

New!!: Primary key and SQL:2003 · See more »

Superkey

A superkey or super-key is defined in the relational model of database organization as a set of attributes of a relation variable for which it holds that in all relations assigned to that variable, there are no two distinct tuples (rows) that have the same values for the attributes in this set.

New!!: Primary key and Superkey · See more »

Surrogate key

A surrogate key (or synthetic key, entity identifier, system-generated key, database sequence number, factless key, technical key, or arbitrary unique identifier) in a database is a unique identifier for either an entity in the modeled world or an object in the database.

New!!: Primary key and Surrogate key · See more »

Table (database)

A table is a collection of related data held in a structured format within a database.

New!!: Primary key and Table (database) · See more »

Unique key

In database relational modeling and implementation, a unique key (also known as a candidate key) of a relation is a minimal superkey for that relation; that is, a set of attributes such that.

New!!: Primary key and Unique key · See more »

Redirects here:

Alternate key.

References

[1] https://en.wikipedia.org/wiki/Primary_key

OutgoingIncoming
Hey! We are on Facebook now! »