Skip to content

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.

Notifications You must be signed in to change notification settings

devamanikantasala/cs50-sql

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

29 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

Course Language Database

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 📒

  1. Cyberchase

  2. 36 Views

  3. Normals

  4. Players

  1. "Packages, Please"

  2. DESE

  3. Moneyball

  1. ATL

  2. Happy to Connect

  3. Union Square Donuts

  1. Don't Panic!

  2. Meteorite Cleaning

  1. Census Tracker

  2. The Private Eye

  3. Bed and Breakfast

  1. In a Snap

  2. your harvard

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

  2. From the Deep

  3. Happy to Connect (Sentimental)

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

About

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.

Topics

Resources

Stars

Watchers

Forks

Languages