Table relationship

In a database, two database tables might be related in some way.

A table can link to a record of a different table, by storing the primary key of the other table’s entry. This is called a foreign key.

Types of relationship

• one to one table relationship
• one to many table relationship
• many to many table relationship