All projects
Data & ResearchCompleted2025
Database Management — Simulated Social Network (DB Lab M1 MITIC)
Role
Database Developer & Analyst
Context
Academic (DB Lab M1 MITIC)
Stack
10 tools
Lab work on managing a SQLite database simulating a basic social network. Project involving manipulation of a 'Reseau_soc.db' database with three main tables: USERS (id, username, password, age), POSTS (id, content, user_id), and COMMENTS (id, content, user_id, post_id). Objective: master data modeling, CRUD operations, advanced SQL queries, and Python script integration for automation, while respecting integrity constraints (primary and foreign keys).
Technologies
SQLiteSQLPythonsqlite3CRUDDDLDMLJOINGROUP BYAgrégats
Deliverables
LDM modeling with 3 tables (USERS, POSTS, COMMENTS)
15 documented SQL queries (INSERT, SELECT, UPDATE, DELETE, ALTER)
Python automation scripts (ajouter_likes.py, dates_aleatoires.py)
Referential integrity constraint management
10-page PDF report with screenshots and analyses
🎯 Results
Functional SQLite database with 3 tables, 15 advanced SQL queries implemented, Python automation scripts created, integrity constraint management mastered. Statistical analyses: average age 28.64 years, 45 posts analyzed, NULL handling and FK dependency management.