/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

28 votes283 views2 answers
Pandas replace nan with value above
Python
4 votes329 views2 answers
Using tqdm in for loop
Python
0 vote264 views1 answer
Tiktok python bot
Python
10 votes291 views5 answers
Rgb to grayscale python opencv
Python
1 vote306 views1 answer
Removing odd index character of a given string in python
Python
7 votes315 views4 answers
From django.contrib import messages
Python Django
1 vote314 views1 answer
How to set "Unnamed: 0" column as the index in a DataFrame
Python
109 votes301 views6 answers
Python string contains substring
Python
3 votes307 views2 answers
Multiple Regression in Python
Python
2 votes263 views1 answer
Python numba
Python