Databases Flashcards
1
Q
What is a primary key?
A
Primary key js a field that uniquely idnetifies each record in a table.
2
Q
What is a composite key?
A
Composite key is a specific type of primary key that uses the contents of two or more fields from a table to create a unique value.
3
Q
What is a surrogate key?
A
Surrogate key is when a table does not have a naturally occurring primarg key and so a new field is created and the surrogate key acts as a primary key.
4
Q
What is a foreign key?
A
Foreign key is a field that is linked to anothet table’s primary key in a relationship between two tables.