Question

relationship between a primary key and foreign key in own and simple language only three line.

Answer 1

Here are the few points about the Primary key and Foreign key:

(1) A primary key cannot accept null values, whereas foreign key can accept.

(2) A table can have only 1 primary key, whereas table can more than 1 foreign key.

(3) Indexes are automatically created on Primary keys, They are not created n foreign key.


Note: Relation between Primary key and foreign key - > One-to-Many relationship.


Hope this helps!