/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 vote139 views1 answer
Python moving average of list
Python
0 vote149 views1 answer
Python check if file is writable
Python
0 vote179 views1 answer
Complex arrays python
Python
34 votes215 views6 answers
Pandas drop row with nan
Python
5 votes177 views1 answer
Check django object exists
Python Django
0 vote145 views1 answer
Pyplot legend outside figure
Python
0 vote147 views2 answers
Python requests get cookies
Python
87 votes138 views6 answers
Write dataframe to csv python
Python
0 vote145 views1 answer
How to use list compression with conditional formatting
Python
-1 vote139 views1 answer
ImportError: cannot import name 'FieldDoesNotExist' from 'django.db.models.fields' (C:\Users\Admin\AppData\Local\Programs\Python\Python39\lib\site-packages\django\db\models\fields\__init__.py)
Python