Role
Database Developer & Analyst
Context
MITIC Academic Project - Group
Stack
6 tools
Educational document on database design: introduction, methodology, CDM-to-LDM mapping, constraints, normalization, and query examples. Group project (Allan, Halima, Michelle, Oussama): modeling and building a database from 10,000 financial transactions to analyze customer purchasing behavior. Complete database design work covering conceptual, logical, and physical modeling, SQL implementation, and data analysis to understand purchasing patterns.
Technologies
SQLBase de donnéesModélisation DEA/MCD/MLDNormalisationAnalyse de donnéesFintech
Deliverables
Complete educational document (introduction, methodology, CDM to LDM)
Complete ERD/CDM/LDM modeling
Normalized database schema (CamelCase)
Integrity rules (entity, referential, data)
Advanced SQL query examples
Results analysis and reporting
🎯 Results
Complete educational database design document produced, functional database created with 10,000 transactions analyzed, full modeling with advanced SQL queries enabling identification of purchasing behavior patterns.