/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 vote114 views1 answer
Plot multiplr linear regression model python
Python
0 vote107 views1 answer
Check if any entries arte none
Python
14 votes133 views1 answer
Create data dir in python
Python
4 votes116 views6 answers
How to change python version
Python
13 votes120 views4 answers
Even in python
Python
1 vote75 views2 answers
Delete a key and value from dict python
Python
0 vote100 views1 answer
Check version of various pkgs
Python
0 vote63 views1 answer
Runpy.py", line 194, in _run_module_as_main return _run_code(code, main_globals, None,
Python
0 vote108 views1 answer
Pandas cartesian product
Python
7 votes107 views2 answers
How to generate requirements.txt django
Python