Database Implementation - aneeshp4/epl-database GitHub Wiki

Database Structure/Schema:

The SQL queries required to build the following schema can be found here.

Importing the Data

We used the table data wizard to import our dataset (in its CSV form) into our database. This CSV has not been modified or decomposed at all since we downloaded it, so all of our manipulation with the data takes place in SQL queries. The wizard created a table for this data, that we called "RawData," which is not considered a part of our final database.

To take the raw data and insert it into the database, we follow the exact steps laid out in our Database Build Plan page, which should function as the details of this implementation. The implementation in SQL of that plan can be found here.

Recreating our database

1. First run EPL_project.sql to create the database and tables.
2. Then import the dataset using the table data wizard. Be sure to name the resulting table "RawData".
3. Run EPL_Database_Implementation.sql to take the data from RawData and insert it into the database.