About this project

‍

Steps to deal with the data:

‍‍

1. Inspecting the data file

Overview of the csv file:

‍

2.Then create the appropriate database schema using lucidchart

Schema I designed for the data:

‍

‍

3.Read csv file in R studio, and populate data into database.

Tables Created in MySql:

4.Analyze data using R

Find the most dangerous flightphase:

Top 10 Airlines of high incidents:

Month with most incidents:

‍

Incidents trends:

What I learned in this project:

• install/procure MySQL or MariaDB
• connect to MySQL/MariaDB from R in an R Notebook
• build a relational schema in at least 3NF (but ideally in BCNF) for an existing data set
• load data from CSV files into a relational database through R
• execute SQL queries against a MySQL/MariaDB database through R
• perform simple analytics in R
• identify and resolve programming errors
• look up details for R, SQL, and MySQL/MariaDB
• time-box work