/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

3 votes256 views1 answer
Pygame unable to open file mp4
Python
62 votes292 views6 answers
Class python
Python
0 vote326 views1 answer
Styling filter form django
Python
0 vote269 views1 answer
Data don't retrieve from database view in django
Python
0 vote309 views1 answer
Unbreakable box made of diamond
Python
0 vote333 views1 answer
Convert pandas dataframe to django queryset
Python Django
3 votes291 views1 answer
Module 'cv2' has no 'videocapture' member python
Python
0 vote327 views1 answer
WSGIPassAuthorization on
Python
22 votes264 views2 answers
How to drop a row in pandas
Python
16 votes308 views6 answers
Dataframe to dictionary
Python