564_final_project

Final Project for SI 564, SQL and Databases, at the University of Michigan

Objective

This repo contains code, data, and other materials for my final project in SI 564, SQL and Databases.

The project components are as follows:

• Turn a dataset into a normalized SQL database
• Create an entity-relationship diagram for that database
• Write a homework assignment using that database
• Complete that homework assignment and create an answer key

Projects were presented in class. The slides used for that presentation can also be found here.

Data

This project uses a dataset of information about trails in U.S. National Parks from AllTrails. The dataset was downloaded on April 4, 2022 and can also be found here on Kaggle.