/Python/Foreign key and primary key difference

Foreign key and primary key difference

PrimaryKey:-

A primary key constrain is a column or group of columns that uniquely identifies every row in the table of the relational database management system. 
It cannot be a duplicate, meaning the same value should not appear more than once in the table.

Foreign key:-
A table can have more than one primary key. 
Primary key can be defined at the column or the table level.
If you create a composite primary key, it should be defined at the table level.
Foreign key is a column that creates a relationship between two tables. The purpose of the Foreign key is to maintain data integrity and allow navigation between two different instances of an entity. It acts as a cross-reference between two tables as it references the primary key of another table. 
Every relationship in the database should be supported by a foreign key.

Difference between primary key and foreign key

primary key and foreign key

-2

Similar codes

1 vote178 views1 answer
How to make a alert box in python
Python
0 vote203 views2 answers
Convert c to phyton
Python
0 vote138 views1 answer
Opencv find image in image
Python
2 votes235 views1 answer
Django template tag to display current year
Python Django
0 vote202 views1 answer
Install python setuptools ubuntu
Python
6 votes224 views2 answers
Python list distinct
Python
0 vote176 views1 answer
Console code page (437) differs from Windows code page (1252) 8-bit characters might not work correctly
Python
0 vote223 views1 answer
Install python 3.9 centos8
Python
0 vote183 views1 answer
Logartim normalization python pandas
Python
6 votes200 views5 answers
How to redirect in django
Python Django