Python - Sqlite database (Implement Constraints-PRIMARYKEY, UNIQUE, NOT NULL, CHECK, DEFAULT)-Part5

Python - How to use Sqlite3 database (Constraints - PRIMARYKEY, UNIQUE, NOT NULL, CHECK, DEFAULT) -Part5
This part covers -
1. How to create table with constraints like PRIMARYKEY, UNIQUE, CHECK, DEFAULT, NOT NULL
2. How application respond when new data does not ensure those constraints
3. How to resolve those constraints
4. How to use IF NOT EXISTS with CREATE TABLE statement to overcome with Table Exist issue