Crowdfunding_ETL

This repository contains all necessary files for Project 2

DATA ACQUISITION:

Located in the Resources Folder:

• contacts.xlsx
• crowdfunding.xlsx

CODE FOR FINAL GRADING

• ETL_Mini_Project_CAvallon_THipkins.ipynb

  • Contains code creating the category DataFrame and is exported as category.csv
  
  • Contains code creating the subcategory DataFrame and is exported as subcategory.csv

* Contains code creating the campaign DataFrame and is exported as campaign.csv

* Contains code creating the contacts DataFrame and is exported as contacts.csv

• crowdfunding_db_schema.sql

  • Has detailed instructions on how to create crowdfunding_db and schema within the new database.
  • Contains SQL code to create and view necessary tables.
  • Includes instructions on which files to import into which table, and the correct order for importing them.

• erd_project_12_crowdfunding.png

  • The sketch an ERD of the tables by using QuickDBD