510 likes | 1.2k Views
Primary key & Foreign key . By: Afra`a Sayah. Primary key & Foreign key. Primary key: It`s uniquely identifies each record in the table. A primary key contains a single column or a set of columns . Foreign key:
E N D
Primary key & Foreign key 7-3d By: Afra`aSayah
Primary key & Foreign key Primary key: • It`s uniquely identifies each record in the table. A primary key contains a single column or a set of columns. Foreign key: • Is a column, or groupingof columns, that contain values that are found in the primary key of some table . A foreign key almost always is not unique. 7-3d
Example 1 7-3d
Example 1 7-3d
Example 1 7-3d
Example 2 7-3d
Example 2 7-3d
Example 3 7-3d
7-3d 7-3d 8-9
Primary Key Featured • Primary Key is always unique • Primary Key never repeated or kept null • Primary Key can be on one column or many columns together. 7-3d
Thank you 7-3d