/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

0 vote174 views1 answer
NameError: name 'views' is not defined
Python
0 vote146 views1 answer
List comprehesion python
Python
0 vote106 views1 answer
Returns all the records as a list of Row
Python
3 votes195 views2 answers
Pandas concat series into dataframe
Python
5 votes138 views2 answers
How to empty a text file in python
Python
0 vote129 views1 answer
Python find first char index from a string stackoverflow
Python
19 votes172 views3 answers
Pil image to numpy
Python
5 votes138 views2 answers
My django template doesnt want to load the static file
Python
0 vote144 views1 answer
Dataframe time index convert tz naive to tz aware
Python
0 vote145 views1 answer
Django.db.utils.ProgrammingError: relation "users" does not exist in django 3.0
Python