a column in a table that refers to the primary key in another table

the way in which two columns in two different tables are related

a list of keys or keywords which identify a unique record and can be used to search and sort records more quickly

the degree to which a database has to be normalized