Question: what is the difference between a primary key and an index?
Answer: A key (minimal superkey) is a set of attributes, the values of which are unique for every tuple (every row in the table at some point in time). An index is a performance optimisation feature that enables data to be accessed faster.