Taxing Trade Route Database

Prerequisites

This project was created using PostgreSQL.

This was the second of three projects as part of the Full Stack Application Development module at the University of Birmingham, focusing on SQL, databases and back-end development.

Goal

The goals of this project are to:

1. Create a database and connect to the database
2. Implement the entity-relationship model of the database as shown below
3. Populate the database with the data facilitated
4. Perform the requested queries on the database.

Entity-Relationship Model

Project Layout

• 'data' folder contains .csv files storing entities, relationships and attributes that will be read, edited and written to with SQL commands.
• 'kxk183_Assignment2.sql' contains SQL and postgreSQL commands that will be run in postgreSQL