IUT - Database application development

Design and implementation of a relational database system for statistical analysis

Cover

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