Explores the process of designing, implementing, and querying a relational database system for a simulated Chicago Police Department case, undertaken to study database system engineering. The project involved transforming a collection of tab-separated data files into a well-structured PostgreSQL database, enforcing data integrity through appropriate schema design, and demonstrating the system’s capabilities with a comprehensive set of SQL queries.
The primary objective was to replace an error-prone spreadsheet-based system with a robust relational database that could handle complex investigative queries, enforce consistency constraints, and support future data growth.