Work
Academic Group Project·2026·1st Semester 2025/2026

Youth Sports Club Management Database

Relational database system in SQL Server for youth sports academy management, featuring 3NF data normalization, 18 transactional requirements, automated T-SQL triggers for attendance and quota generation, stored procedures, and custom business constraint validation.

Section 01

Structuring and automating sports academy management with SQL Server.

Developed for the Database Systems course at Politécnico do Porto, this project designs and implements a robust relational database system supporting the complete administrative and athletic operations of a youth sports club across multiple seasons.

Following Connolly & Begg's 3-phase database design methodology (Conceptual, Logical, Physical), the schema centralizes player registrations, age categories, technical staff assignments, training attendance, monthly fees, and automated compliance alerts in Microsoft SQL Server.

3NFNormalization Level Reached
18Transactional Requirements Implemented
AutomatedTriggers for Attendance & Fee Alerts
SQL ServerDatabase Engine
Youth Sports Club Management Database

Conceptual Entity-Relationship (ER) diagram illustrating entities, cardinality, and key constraints

Section 02

The Problem & Key Challenges

Youth sports academies suffer from decentralized data management, leading to unmonitored financial debts, untracked player attendance, and administrative overhead.

The project constructs a fully normalized (3NF) relational database enforcing strict referential integrity, automated fee generation upon registration validation, auto-logging training attendance, and low-attendance (<50%) and federative renewal alerts.

Key Engineering Challenges
  • Normalizing unstructured club data from UNNF to 3rd Normal Form (3NF), eliminating modification and deletion anomalies
  • Implementing automated T-SQL triggers auto-generating attendance records upon training creation and initial quotas upon registration validation
  • Coding business logic CHECK constraints ensuring age-category eligibility and preventing future-dated attendance logging
  • Enforcing strict referential integrity blocking new season registration validations if past-season fee debts remain unpaid
  • Developing 18 complex transactional Stored Procedures, Views, and Scalar Functions for administrative reporting
Section 03

Architecture & Technical Decisions

3-tier database architecture designed with Connolly & Begg methodology, fully normalized to 3NF and implemented in Microsoft SQL Server with Stored Procedures, Triggers, Views, and Sequences.

System Topology & Component Flow Diagram
Loading architecture topology...
Why This Architecture
  • Formal 3NF normalization eliminates data redundancy and insertion/deletion anomalies across multi-season histories
  • Database-level triggers enforce business rules atomically without relying on external application code
  • Custom Stored Procedures and Views optimize query execution speed for administrative reporting dashboards
Section 04

Tech Stack & Infrastructure

SQL Server
T-SQL
All projects