Project Overview
After modeling and implementing a database populated with the information provided about the Titanic incident, we performed analyses to extract insights about the passengers and the crew. 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. SQL queries were used to extract key indicators, formalized as descriptive statistics.
Finally, we created an analysis report to visualize the results obtained from our queries and draw conclusions from them.
Project Results
-
Set up of a relational database covering Titanic passengers and crew.
-
Extraction of demographic and survival indicators using SQL queries.
-
Generation of descriptive statistics.
-
Final grade: 17.5 / 20.
This project enabled the development of skills in conceptual and logical data modeling, advanced SQL querying, and interpretation of statistical results, serving as a first practical application in data science.