Project 3 - Database Creation & Data Analysis on Titanic

Expertise

Data Science

Bachelor Skills

Skills 4

Skill 4: Designing and implementing a database based on client specifications

Technologies

SQL

Github

Take a look

Project Overview

We modeled and implemented a database that we populated with data from the Titanic incident made available to us.

The goal was to perform analysis on this database to obtain information about the passengers and crew members of the Titanic. Our analysis included exploring various aspects such as passenger demographics, survival rates, and relationships between different variables.

First, we performed the SEA (Structured Entity Analysis) and SLR (Structured Logical Representation) to modelize our database :

The next step was to code the database using SQL. We created the create.sql file to define the structure of the database and create the necessary tables.

The analysis included exploring various aspects such as passenger demographics, survival rates, and relationships between different variables. We used SQL queries to extract meaningful insights from the data and present them in a visually appealing manner.

Finally, we created a data analysis report with graphs to showcase the results obtained from our queries.

Results

We achieved the set goal by creating a functional database and performing SQL queries to obtain information about the passengers and crew members of the Titanic.

We also conducted data analysis to gather insights about the passengers and crew members of the Titanic. The final project score was 17.5/20.

I have learned a lot about database design and data analysis through this project and also improved my SQL skills by learning how to extract meaningful insights from data using SQL queries. This project introduced me to the world of data science and provided me with valuable experience that will be beneficial for my future career.