Python Programming

The below Python projects demonstrate the use of Python programming to solve optimisation problems, including road planning, food order, and a variation of the Travelling Salesman problem.

Road Planning Optimisation

The following project optimises a road planning problem in a hypothetical town using Python, where the objective is to minimise the total cost of road construction while allowing the town to still be connected.

Food Order Optimisation

This optimisation project uses Python to solve a food order problem, where the objective is to minimise the cost of food orders while ensuring that all food orders are fulfilled.

Travelling Salesman Variation

This project uses Python to solve the Travelling Salesman problem, where the objective is to find the shortest possible route that visits each site exactly once and returns to the origin site. However, an additional constraint prevents the salesman from travelling North-South or South-North.

SQL Programming

The below projects demonstrate the use of SQL programming to create databases and analyse data, including a database creation project and a bookshop analytics project.

Creating a Database in SQL

This project demonstrates the creation of a database in SQL, including the creation of tables, insertion of data, and querying the database.

Bookshop Analytics in SQL

This analysis is based on a dataset from a fictional bookshop. The dataset contains information about the bookshop's customers, orders, and books. The goal of this analysis is to identify trends and patterns in the data that can help the bookshop improve its operations and increase its revenue.