In this project, a database is created for an organization based on six existing separate tables of data in csv form. Relationships between the tables are defined based on the existing data. In the new relational database, specific queries are performed.
Tools used: QuickDBD, SQL, pgAdmin.
Step 1: In QuickDBD, an ERD was drawn for the six tables and their respective relationships.
Step 2: The SQL code exported from QuickDBD, opened in pgAdmin and cleaned up.
Step 3: The relevant csv tables were imported for all 6 tables
Step 4: In a second query tool window, the queries were performed, the code saved in SQL
