Skip to content

README.md

Latest commit

 

History

History
123 lines (81 loc) · 3.29 KB

README.md

File metadata and controls

123 lines (81 loc) · 3.29 KB

CS50 SQL Banner

Harvard CS50’s Introduction to Databases with SQL — CS50SQL 2023

🎓 Course Link

⚠️ Academic Honesty Disclaimer

This repository is shared strictly for educational purposes. It is intended to help others learn from structure, approach, and design — not to be copied or submitted as their own.

CS50 has a strict academic integrity policy. All final projects are subject to manual review, and if your submission is found to be plagiarized, copied, or unoriginal, your edX and GitHub usernames can be permanently banned from CS50.

Please use this repository to:

  • Understand how to approach the problem sets and final project
  • Learn best practices in SQL schema design and query building
  • Get inspired to build your own original and creative final project

✅ Do not copy-paste any part of this repository directly
✅ Always write your own code
✅ Be proud of your own learning and creativity

Let’s keep the CS50 community honest, supportive, and brilliant!

🏅 Certificate of Completion

I have successfully completed CS50's Introduction to Databases with SQL by Harvard University, earning a certification like below in June 2025.

CS50 SQL

The course included:

  • ✅ 7 hands-on problem sets
  • ✅ 1 final project submission

📁 Repository Structure

SQL-CS50/
├── Assignments/         # All 7 problem sets and solutions
├── FINAL-PROJECT/       # CampusConnect — Final Project files
├── LICENSE              # MIT License
└── README.md            # You're here!

📚 Table of Contents

🕹️ Week 0

  • Cyberchase
  • 36 Views or Normals
  • Players

🔗 Week 1

  • "Packages, Please"
  • DESE
  • Moneyball

🧱 Week 2

  • ATL
  • Happy to Connect
  • Union Square Donuts

🚨 Week 3

  • Don’t Panic!
  • Meteorite Cleaning

🏠 Week 4

  • Census Taker
  • The Private Eye
  • Bed and Breakfast

📊 Week 5

  • Snap
  • Harvard

📈 Week 6

  • Happy to Connect (Sentimental)
  • Don’t Panic! (Sentimental) — Python Version

🎓 Final Project: CampusConnect

CampusConnect is a relational database designed to manage campus events and student participation. It allows:

  • Creating and managing user profiles
  • Organizing and attending events
  • Viewing interests and participation analytics

📌 See FINAL-PROJECT/ for schema design, sample queries, and project documentation.

🛠️ Tools & Technologies

  • SQL (SQLite)
  • DB Browser for SQLite
  • Harvard CS50 IDE
  • ER modeling & schema design

📫Any doubts? Connect with me: bleegleewee

“Without data, you're just another person with an opinion.” – W. Edwards Deming