/Module-9-Challenge

Challenger for UNCC Data Analytics Bootcamp involving SQLAlchemy using data regarding the weather in Hawaii

Module 9 PostgreSQL Challenge for UNCC Data Analytics Bootcamp

Hello graders! This challanges was awesome introduction to SQL!

File Directories

Connection String

  • connectionstring.py

Data

  • departments.csv
  • dept_emp.csv
  • dept_manager.csv
  • employees.csv
  • salaries.csv
  • titles.csv

Information

  • csvinfo.txt - contains information about the CSV files
  • databasediagram.txt - database diagram
  • img.png - screenshot of the database diagram

PostgreSQL Scripts

  • analysis.sql - analysis script
  • create_table.sql - create table script

Screenshot of diagram and of the sql script being executed

img image