I lead this project where we built a payroll management system database from scratch, we came up with an E-R diagram, then implemented it with PostgreSQL. we also built a CLI with Python to operate and perform simple to complex queries. The related files ad pdfs are added in the repository.
Steps to excecute the project :
-> install postgreSQL on your System
-> Run create.sql and insert.sql programms
-> Install psycopg2 through "pip install psycopg2"
-> replace user and password in line 4 of CLI.py with your credentials.
-> run the program and you're good to go.

For any queries mail me @kumarstejas14@gmail.com