Project Vaccine Distribution

Overview

The main objective of the project is to build a database to keep track of the different vaccine types, transportation of vaccine batches, treatment plans, staff schedules of vaccinations events, and patient data for Corona vaccine distribution and treatment in Finland.

File structure

This section explains the recommended file structure for the project

.project-vaccine-distribution
├── code                              # code base (python & sql files)
│   ├── requirements.txt              
│   ├── test_postgresql_conn.py       # Example code to test connection with postgres server
│   ├── ....py                       
├── data                              # contain the sample data for Vaccine Distribution projects
│   ├── sampleData.xls                # sample data as an excel file
├── database                          
│   ├── database.db                   # final version of the project database
├── venv                              
│   ├── bin
│   │   ├── activate
│   │   ├── ....
│   ├── ....
├── .gitignore
└── README.md

Purpose of the database

The purpose of the database is to model and manage the distribution of vaccines. The database is designed to track information about vaccine manufacturers, vaccine batches, vaccination events, patients, and symptoms.

Handling of the database

Setting up the database First, we need to run the files ‘creating_the_database.py’ to create the database, connect to it and fill it with the provided data.

Queries for creating tables

The queries needed for creating the tables and filling them with the provided data are contained in the file ‘Script-2.sql’, and we could run it with the same file mentioned above.

Queries for the data visualization

The queries used to visualize the data are located in the file ‘visualization.py’. After running the file, we should have the plots and figures as outputs.