/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

19 votes114 views1 answer
Python substring from end
Python
7 votes129 views4 answers
Python tkinter button multiple commands
Python
0 vote126 views1 answer
Write a python program to find table of a number using while loop
Python
11 votes116 views2 answers
Adding to python path
Python
2 votes82 views2 answers
Flask hello world get
Python Flask
11 votes146 views2 answers
How to print a list without brackets and commas python
Python
0 vote123 views2 answers
Avoid bad request django
Python
-1 vote110 views2 answers
Microsoft visual c++ 14.0 is required
Python
0 vote115 views1 answer
Pie chart maptlotlib larger labels
Python
0 vote123 views1 answer
How to import qpalette pyqt5
Python