CS50's Introduction to Databases with SQL: Coursework Solutions and Final Project

Introduction

This repository contains my solutions for the weekly problem sets and the link to the final project for Harvard University's CS50 SQL course. It demonstrates various concepts learned throughout the course, including database design, SQL querying, constraints, views, indexes, and triggers.

Weekly Assignments 📒

Problem Set - 0 🧩

1. Cyberchase

2. 36 Views

3. Normals

4. Players

Problem Set - 1 📦

1. "Packages, Please"

2. DESE

3. Moneyball

Problem Set - 2 🔗

1. ATL

2. Happy to Connect

3. Union Square Donuts

Problem Set - 3 🚀

1. Don't Panic!

2. Meteorite Cleaning

Problem Set - 4 🕵️

1. Census Tracker

2. The Private Eye

3. Bed and Breakfast

Problem Set - 5 ⚡

1. In a Snap

2. your harvard

Problem Set - 6 🐍

1. "Don't Panic!" (Sentimental) in Python or Java

2. From the Deep

3. Happy to Connect (Sentimental)

Final Project 🏆

Final Project: Neighbourly 🤝 - Local Marketplace Support System

The final project involved designing and implementing a database schema for a conceptual local marketplace application.

Key focus areas:

• Designed a relational database schema with appropriate entities and relationships.
• Focused on data integrity using foreign key constraints, and column constraints.
• Optimized query performance with VIEWs, INDEXs, and TRIGGERs.
• Ensured all the relevant data movements are logged for further analysis.

➡️ Find the full project details, schema, queries, ER Diagram, and video presentation in the Final-Project repository. (Make sure to check out the README.md within the Final-Project repository for a detailed explanation!)

By,
Deva Manikanta Sala