Relationships between tables

You use primary keys and foreign keys to describe relationships between the information in different tables. Primary keys identify each row in a table uniquely, and foreign keys define the relationships between rows in different tables.

Primary keys and foreign keys let you use relational databases to hold information in an efficient manner, with minimum redundancy.

 See also