Database1 Lab Introduction: Primary Key Concepts

To ensure that each row in the table is unique and identifiable

The column must be unique within the entire table

To establish a relationship between two tables

The 'Department' table is the parent table, and the 'Employee' table is the child table

To establish and maintain logical relationships between tables to avoid data corruption

It does not allow to add any record in a table that contains the foreign key unless the reference table containing a corresponding primary key.

You must check that there are no records in related tables that require the record which you are deleting.

You must check that the related information exists in parent table in PK column before adding information to a table.

You can not delete the primary key if it has Dependencies (FK related to it).

The value of a FK must exist in the PK column it refers to.