Final Review Flashcards
(6 cards)
1
Q
What is another word for a column or field?
A
Attribute
2
Q
What is another word for a row?
A
Record
3
Q
What is a primary key?
A
A unique identifier for each row (record) often of datatype Autonumber.
4
Q
What is a foreign key?
A
A connector used to provide associations between tables and should be related to the primary key in the related table. It always goes on the many side of the relationship.
5
Q
What is a composite key?
A
A primary key composed of more than one attribute.
6
Q
Short Text
A
Text fields up to 255 characters. To limit, set field size.
