Home

Welcome to the EarthquakeData Project Wiki!
This project uses an earthquake dataset available on Kaggle. You can access it here.

In this wiki, we outline some interesting questions that could be answered using the available earthquake data.

1. What is the frequency of earthquakes on each continent, sorted in descending order?

2. In which month do the deepest earthquakes typically occur?

3. Which locations (specified by city and country) have experienced earthquakes of magnitude greater than 6 that triggered tsunamis?

4. How has the frequency of severe earthquakes (magnitude > 7) changed over the last decade?
   

The above dataset meets the requirements of the assignment. The database consists of data on 782 earthquakes. Furthermore the dataset consists of 19 columns, many of which are redundant, which is ideal for normalizing the dataset. The answers to the questions above can also provide useful analysis of the data.

Table of Contents

• Project Overview/Dataset Info
• Database Design
  • ERD Description
  • Database Build Plan
• Database Implementation
  • Implementing Database Schema
  • Importing Data Into Database
• Executing SQL Queries on Normalized Database
• Database Project Enhancement
  • Progress Timeline
  • Project Summary/Enhancement Documentation
  • Answering Questions with Enhanced Features
• Reflections and Troubleshooting
• References