RELATIONSHIP BETWEEN PRIMARY KEY AND FOREIGN KEY

RELATIONSHIP BETWEEN TWO TABLES

Connections between fields of related tables having common values are called relationships.

A relationship works by matching data in key fields, usually a field with the same name in both tables.

These matching fields are the primary key from one table and a foreign key in the other table.

IMPORTANCE OF THE RELATIONSHIP BETWEEN PRIMARY KEY AND FOREIGN KEY

The primary key of one table becomes a foreign key of the other table.

By matching a foreign key with a primary key, the data does not need to be entered repeatedly.

A primary key makes creating Queries, Forms and Reports easier.

A primary key improves data performance by relating smaller tables into meaningful databases.

__________________________________________________________________________________
 Others Lesson : | click lesson to view |

• Database and DBMS
  
• Relationship Between Field And Record
  
• Primary And Foreign Key
  
• Relationship Between Primary and Foreign Key
  
• Database Object - Query
• Database Object - Form
• Database Object - Report
• Data Manipulation