Building a database with crime report data

Summary:

This project builds a database, schema, tables, and user management privileges with proper datatypes in Postgres from a CSV file on crime data in Boston. Completed as part of the "Postgres for Data Engineers" course from Dataquest.io.

Data:

• boston.csv - csv file with crime report data from Boston, accessed from Dataquest.io "Postgres for Data Engineers" course

Documents:

• Crime+Report+Database.ipynb - Jupyter notebook detailing all steps taken with explanations
• Crime+Report+Database.py - script that builds and tests database