Primary Keys

• Primary key is a column (or combination of columns) whose value uniquely specifies a table record
• Not all database tables need a primary key
• You need a primary key if you want to establish a link from another table
• Foreign key is a reference to a primary key in a linked table
• Foreign keys need not be unique