Looking back at my first contact with databases in 2022, Fiftyville stands out as the best and most educational project I have worked on. This project was instrumental in deepening my understanding of SQL and database management. I decided to share it in the hopes that it might help someone else on their learning journey.
The CS50 Duck has been stolen! The town of Fiftyville has called upon you to solve the mystery of the stolen duck. Authorities believe that the thief stole the duck and then, shortly afterwards, took a flight out of town with the help of an accomplice. Your goal is to identify:
- Who the thief is,
- What city the thief escaped to, and
- Who the thief’s accomplice is who helped them escape.
All you know is that the theft took place on July 28, 2021, and that it occurred on Humphrey Street.
How will you go about solving this mystery? The Fiftyville authorities have taken some of the town’s records from around the time of the theft and prepared a SQLite database for you, fiftyville.db, which contains tables of data from around the town. You can query that table using SQL SELECT queries to access the data of interest to you. Using just the information in the database, your task is to solve the mystery.
- Complex Queries: Utilizes advanced SQL queries to extract and manipulate data.
- Data Analysis: Applies analytical techniques to interpret results and make informed conclusions.
- Real-World Scenarios: Simulates real-life database challenges and problem-solving.
- Advanced SQL Skills: Develop proficiency in writing and optimizing complex SQL queries.
- Data Manipulation: Gain experience in data filtering, joining, and aggregation.
- Problem Solving: Enhance your ability to approach and solve intricate data-related problems.
A special thanks to Harvard University for the inspiration and resources provided through the CS50 course.