Welcome to the repository for the final project of CS50's Introduction to Databases with SQL course.
This repository contains the code to create the Paris Olympics database in PostgreSQL, insert the data in tables, optimize searches using indexes, and queries to retrieve individual athlete and teams information, the distribution of participants and medallists, and the top performing countries.
- DESIGN.md: Database design information
- schema.sql: code to create the database schema
- queries.sql: sample queries to retrieve athlete and medal information
- login.sql: information to login to PostgreSQL in Docker
- postgreSQL
- codespaces
- docker
- mermaid.js
This repository is for educational purposes only.