Cleaned data spreadsheet: https://docs.google.com/spreadsheets/d/1AnF_UNyJC0YlDczPMuZ6vH7ZuV89WmK7inokxDfqWvo/edit?usp=sharing
Final presentation (Google slides): https://docs.google.com/presentation/d/1Hs1bJZQZJ2m7ThpLYGUhTt9QnMWYdTcSoYJMvUsa0TM/edit?usp=sharing
Our final project addresses a real-world challenge: creating a relational database for an educational institution that currently lacks a DBMS (database management system). The project is grounded in the specific needs and requests of an actual independent high school, referred to as "Academy X" in this report. Academy X aims to better understand trends in student outcomes by leveraging data from its Admissions Office and College Counseling Office. This project explores the practical challenges of integrating siloed databases and demonstrates the use of SQL queries and visualizations to generate high-value insights for the institution.
- Data Generation: code for generating the application data according to specs
- ERD: Data map
- Relational Database: hosts the database, final CSV files, and all queries run
- Report and Presentation: final report and slides
- cleaned data and raw data: backup copies of CSV files from different stages of the data cleaning process