Context

Academic project completed during the first semester of Bachelor’s in Computer Science, focusing on relational database design and implementation using PostgreSQL.

Objective

Development of a relational database management system for analyzing Titanic disaster statistics, emphasizing:

• Normalized database schema design
• Complex SQL query implementation
• Statistical data analysis and visualization

Implementation

Project execution followed three distinct phases:

1. Database design

• System requirements specification
• Entity-relationship modeling
• Business rule definition
• Schema normalization (3NF)

2. Development

• PostgreSQL implementation
• ETL process and data validation
• Query performance optimization
• Statistical computation implementation

3. Data analysis

• Advanced SQL query development
• Statistical data extraction
• Visualization implementation using RAWGraphs

Results

Key deliverables:

• Third Normal Form (3NF) compliant database
• Optimized SQL query set for statistical analysis
• Data visualization dashboard
• Technical documentation including design rationale